Copy from worksheet to end of list on second worksheet

[redkilner]

I would like to be able to copy a list of information I exported from a database into my worksheet I have developed to analyze the information. I already have a list of data in the worksheet but would like to add the new information to it. I need to be able to copy from the exported csv file and paste it to the end of the data that is already in my worksheet. Here is the code I have developed so far. Instead of copying A2:T1500 I would like to be able to copy "All data" and instead of pasting to B58 I'd like to paste to "first empty row".

Please Login or Register  to view this content.

[tigeravatar]

redkilner,

Here's one way....

Please Login or Register  to view this content.

[redkilner]

Works great! Thanks!

[tigeravatar]

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save