+ Reply to Thread
Results 1 to 2 of 2

Copy cells of all files starting with PJ from folders and sub folders to master document

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Derby, England
    MS-Off Ver
    2010, 2013 2016 Pro
    Posts
    85

    Copy cells of all files starting with PJ from folders and sub folders to master document

    I have an increasing number of files (Project Files) that increase weekly (Approximately 20 a week) they are stored in a Project folder and then in Engineers Name Sub folder and then in Week sub folders

    What I want to do is search all sub folders from within a folder for all PJ*.xlxs files and then copy cell values from the individual files and compile them into a master file

    I need to copy Individual Cells as shown in Master Document.xlxs this is compiled from files PJ-04-0001.xlxs and PJ-06-0989.xlxs, the Master Document shows the cells to be copied from the Project Files (PJ-04-0001.xlxs and PJ-06-0989.xlxs).

    The (Project Files) PJ files are a sample of the format we use.

    Master Document.xlsx
    PJ-04-0001.xlsx
    PJ-06-0989.xlsx
    Last edited by RoyLittle0; 09-11-2013 at 09:13 AM.

  2. #2
    Registered User
    Join Date
    01-04-2012
    Location
    Derby, England
    MS-Off Ver
    2010, 2013 2016 Pro
    Posts
    85

    Re: Copy cells of all files starting with PJ from folders and sub folders to master docume

    Anyone got any ideas ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Recursively Count Files in Folders and Sub-Folders
    By cdeshaz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2013, 01:15 PM
  2. Update files between Master and Source workbooks in sub-folders
    By sans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2013, 06:07 AM
  3. [SOLVED] Copy range from multiple files in multiple folders to single sheet in master WB
    By Royzer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-18-2012, 03:40 PM
  4. Create folders and move and copy files into that folders
    By vijaybharthi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2010, 04:01 AM
  5. document register of files and folders
    By Suej68 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2010, 06:02 PM

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