Hello Everyone
I have two different workbooks in same folder path and both workbook has same column headers too.
From A5 to S5, headers and then from A6 i have data in both the workbook
I want to copy one workbook one workbook to other workbook and i have below code for tha
I am facing some issue to amend this code as my requirement.
1. Workbook Path - I am going to run this macro from other 3rd workbook and have copy and destination workbooks path in their cell in E1 and E2
2. Worksheet Name - I don't know the copy and destination sheet name but data is available on first sheet which name can we anything. (can we amend the sheet name in this macro and then perform our action or what would be best way?)
3. Copy and paste data. help me with the giving range of copy and destination range.
your prompt response will be highly appreciated. help me pls
Bookmarks