I have data that is imported into Excel in tab delimited formatting. I've included a screen shot of the spreadsheet just for clarification purposes as well. The data is reported in a neat manner but I need to reformat the data in order to make other calculations easier, so I've chosen to copy certain aspects of the data to a new sheet. I was trying to use DataRange.End(xlDown) function to select the data for each trajectory( Block of data on spreadsheet) but in my code when I run the sub only the last cell of data is being copied to the new sheet.
Here is what I've written so far:
Also, is there an easy way to alter this code so it can copy all the data for columns B2 and C2 and display them in the newly created worksheet?
Bookmarks