Results 1 to 1 of 1
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Thanked 12 Times in 12 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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts