Archive data from one sheet to last row of another sheet

[pjw23]

I'm looking for some assistance on how to grab data from one sheet and move it to the last written row of another sheet.

For instance. I would like to take worksheet1 cells A5:A100 and import them into the last written row of Worksheet 2 Column C, and then the same thing for worksheet1 cells d5:d100, but import them into column A. I was able to figure out how to identify the last written row of the sheet, but can't figure out how to copy multiple cells into a specific row. If anyone has any ideas I'm all ears, below is an example of the code I've been messing witht, but can't seem to make it work. Thanks in advance for all help.

Please Login or Register  to view this content.

[barryleajo]

Hi pjw23
One way to get you going

Please Login or Register  to view this content.

[pjw23]

BarryLeaJo,
Thanks for the reply. It does the copy to the other sheet, however, for some reason when putting the data into "sheet 2" instead of writing to the last written row, it uses the last written row count of "sheet 1" For instance, I have 68 rows in sheet 1, when I run the macro using the code, it writes sheet 2 starting at line 69 even though the last written line is row 9. Any ideas how to fix it? Thanks.

[barryleajo]

Hi pjw23
OOPs - this should now work

Please Login or Register  to view this content.

[pjw23]

Wow, that works great, thank you very much!!!

[barryleajo]

OK pjw23
If this meets your needs please Mark your thread as SOLVED