+ Reply to Thread
Results 1 to 3 of 3

Update files between Master and Source workbooks in sub-folders

  1. #1
    Valued Forum Contributor sans's Avatar
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    550

    Update files between Master and Source workbooks in sub-folders

    Hi to all,

    I have a folder named A which contains numerous subfolders in many levels. Each subfolder contains only one file (a Master file) and in each Master file there are many sheets.


    Now I have another folder named B .This folder is exactly the same as A. It has the same folder structure and folder/subfolder names. Folder B contains all the files that I need to use to update the master files in Folder A.


    Below you can see an example of the folder structure. For instance,


    Folder A

    Subfolder 1
    Test 1.xlsm (this Master file contains sheets named 1,2,3,4,5)
    Subfolder 2
    Test 2.xlsm (this Master file contains sheets named 6,7,8,9,10)


    Folder B

    Subfolder 1
    1,2,3,4,5 (These are the individual sheets that are found in Test 1.xlsm)
    Subfolder 2
    6,7,8,9,10 (These are the individual sheets that are found in Test 2.xlsm)



    What I would like to do is to copy a range from each file from Folder B and to paste it in the correcsponding master file/sheet in folder A.


    For example,

    From Folder B, Subfolder 1, sheet named 1, I would like to copy range A1:A100 and paste it in the sheet named 1, in the Master file Test 1.xlsm (which is essentially the Master File in the corresponding Subfolder 1, in Folder A)
    From Folder B, Subfolder 1, sheet named 2, I would like to copy range A1:A100 and paste it in the sheet named 2, in the Master file Test 1.xlsm (which is essentially the Master File in the corresponding Subfolder 1, in Folder A)

    and so on.


    If anyone could offer some help with the above it would be amazing.


    Thank you.
    Last edited by sans; 01-26-2013 at 07:06 AM. Reason: Re-phrase question

  2. #2
    Valued Forum Contributor sans's Avatar
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    550

    Re: Update files between Master and Source workbooks in sub-folders

    If I am being unclear in the post above please let me know. Thank you

  3. #3
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Update files between Master and Source workbooks in sub-folders

    Cross posted here: http://www.thecodecage.com/forumz/mi...ubfolders.html
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1