Solved: Copy a range of data and paste to the last row of another workbook

[bananatang]

Hi,

I need a macro that will copy a selected range from an existing worksheet in a workbook and paste the data to the last row in another workbook on a particular worksheet.

Any help would be apprecaited.

Thanks BT

[n8Mills]

Easy one!

Range("yourRange").Copy Workbooks("Different Workbook.xls").Sheets("Whatever Sheet").Range("A65536").End(xlUp).Offset(1, 0)
This assumes that column "A" will by your baseline for the "last row", and that you want to paste into the "A" column

[bananatang]

Hi N8mills,

Thank you for your help.

The code you provided works great.

Many Thanks.

BT

[n8Mills]

No problem. Could you mark the thread as "Solved" now? It's under "Thread Tools" at the top.

Best regards,

Nate