Copy rows from one workbook to another

[akulka58]

Hi All,

I do have 2 workbooks.

1) Template.xlsx
2) Worth.xlsx

I need to open Worth.xlsx and activate sheet named as “ISSUES”.

After activating “ISSUES” sheet I need to copy all rows from “Issues” and paste in Template.xlsx (Sheet name is “Worth ISSUES”). Data should pasted from row number 2 because 1 row has header.

After pasting data “ISSUES” sheet must deleted from worth.xlsx and save

I need to open both workbooks via application.getfileopen command. So that user can select both workbooks. (Folder path always change that’ why)

Error Handling: - If “ISSUES” sheet does not exist then code should how msgbox and exit macro.

Please help.

[ihmha]

I adapted this from something I already have.
It might be a bit long winded but it should work.

Please Login or Register  to view this content.

[akulka58]

Hi Ihmha,

Thanks a lot for your reply. But its copying data in master workbook. I need to open Template.xlsx. Code should not copy data in macro book.

[ihmha]

Added some revise code and error handling.
You would need to have the template.xlsx workbook in the same directory for it to run, or make this a personal macro which allows you to run it on any workbook.

Please Login or Register  to view this content.