macro copy range workbook A to workbook B

[JEAN1972]

Hi All

Macro to copy range A TO Z to last data row sheet (data) in workbook A to another workbook B sheet( compile data) with same range of data but do not overwrite existing data in worksheet B(COMPILE DATA)

Both sheet has same headers at row1

Thanks if any can assist

[jindon]

Untested.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[JEAN1972]

Jindon and John thank you for help

[JOHN H. DAVIS]

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