Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2015
    Thanked 0 Times in 0 Posts

    Open, Copy, and Paste macro in Excel 2010

    I need a macro that will read a list of 11 file names in a workbook. Then, I need to copy each the contents of each file into a specific, individual tab in the original workbook. The files that are being opened are all .csv. This is the table of tab names and file names that I am working with (located in B3:C14 in the original workbook):


    All of the files to be opened are located in the same folder. I have the path to the folder in cell B2 of the original workbook. The tabs in the original workbook already exist and are labeled accordingly.

    Last edited by dansparks81; 2015-08-20 at 18:28.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    New York, New York, USA
    Thanked 17 Times in 17 Posts
    Dear Dansparks81

    Welcome to the Lounge.

    Attached is an Excel File with a Macro that should do what you wanted.

    Please note the Macro needs the following or it will not work.

    The path name must be in Cell B2
    All file names must begin at Cell D6

    You will need to add the missing worksheets to the file.

    Lastly the Macro will fail if for any reason you add or delete rows or columns in the worksheet containing the filenames

    Good luck.

    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