Results 1 to 1 of 1
2015-06-03, 09:35 #1
- Join Date
- Feb 2008
- Thanked 7 Times in 7 Posts
Macro to Open workbooks and copy data to respective sheets
I have written code to open two workbooks and to copy the data to sheet(2) (New Inventory) and to sheet(3) (Used Inventory)
The macro allows me to select the workbooks to be copied, however, new worksheets are created and the data copied into the new sheets
1) I want the data from the first file selected to be copied to sheet(2) "New Inventory"
2) I want the data from the second file selected to be copied to sheet(3) "Used Inventory"
The source data only has one sheet
It would be appreciated if someone would please assist me in amending the code so that the data is copied to the correct sheets
I have attached a workbook sample
I have also posted on Mr Exccel.com