Copy all rows from one Workbook1.Sheet2 to Workbook2.Sheet3 and append them

[dubcap01]

Hi all,

I know the title doesn't do justice to what I need to achieve, and there are plenty of threads for copying and pasting from one worksheet to another, but I cannot find any code to copy from a sheet in one workbook, and then paste in the next blank row in a sheet in another workbook! It's the link to another workbook that always seems to be missing.

I could paste example code of what I think should but doesn't work, so rather than embarrass everybody including myself, I will not attempt it here! Instead, I ask humbly for someone to assist me with the PROPER code to copy all populated rows from Workbook1.Sheet2 and paste into Workbook2.Sheet3 in the next blank row. Both workbooks will be open when the code is triggered....

Many thanks in anticipation, and I apologise in advance if I have erred or broken forum rules.

a very exhausted
Pete

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[BellyGas]

Disregard, John solved it.

[dubcap01]

Thanks John and Belly Gas

As stated John solved it. Much appreciated guys

Pete

[JOHN H. DAVIS]

You're welcome Pete. Glad to help out and thanks for the feedback and the reps.