Results 1 to 1 of 1
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,422
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Code to open up worbooks and copy data

    I have several workbook that I need to open and copy the data into sheet1 of the destinational workbook

    All the headers in the source workbook are the same

    I would like VBA code to do the following

    1) To copy the data including headings from the first workbook in sheet1 on the destination workbook
    2) All subsequent workbooks, except headers to be copied in the row after vwhere the previous data has been copies

    I have attached a sample workbook

    Your assistance in this regard is most appreciated
    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
  •