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.
Bookmarks