Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2017
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to transfer the complete content of a workbook (in a specified path/folder) to 'master workbook'

    hello

    i am new and relatively unskilled in excel and VBA and hoping for some guidance.

    i have a folder of saved excel files containing data (each workbook has the data saved in the same format but contains unique data).
    i am hoping to be able to have one separate 'master workbook' that has the capability to call upon the path of a certain saved file (containing the unique data) and transfer the all of the contents of the saved file to the master file by using a single cell.

    any guidance would be greatly appreciated

    kano1

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    9,108
    Thanks
    64
    Thanked 1,125 Times in 1,048 Posts
    This post seem to be asking the same question and has lots of code for you to use.
    https://windowssecrets.com/forums/sh...o-master-sheet

    cheers, Paul

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,442
    Thanks
    166
    Thanked 651 Times in 619 Posts
    Hi kano1

    Welcome to the Lounge as a new poster.
    It always helps us to help you if you could attach a sample data file.

    zeddy

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,442
    Thanks
    166
    Thanked 651 Times in 619 Posts
    Hi kano1

    see if this helps


    zeddy
    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
  •