+ Reply to Thread
Results 1 to 10 of 10

Need folders copies into other folders based on excel list

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Need folders copies into other folders based on excel list

    1. I have a directory of folders with the part number as the name on each folder (1208 folders)
    2. I have a directory of folders with the job number as the name on each folder. (88 folders)
    3. I have an excel file that matches the job number to the part number.

    Is it possible to query the excel file and find a specific job number, go to the job directory and copy the matching job folder and then query the excel file for the matching part number and go to the directory with the part number folders and paste the job number folder into the matching part number folder?

    First post to this forum so I hope this makes sense, but fire away with the questions if it doesn't.

    Thanks

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Need folders copies into other folders based on excel list

    I think so, but attach a sample file and be less vague
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need folders copies into other folders based on excel list

    Example File.pdf

    I had a long explaination but somehow it got lost so here is a truncated version.

    Here is the example file with the excel file list that has the job number and the part numbers listed. I am hoping that the first job number on excel list can be used to find the corresponding job folder and copy that folder into the part number folder. The part number that matches the job number is shown on the same excel list.

    Then go to the next job number and repeat the process.

    Thanks

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Need folders copies into other folders based on excel list

    how can I use a pdf file ?

  5. #5
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need folders copies into other folders based on excel list

    I had all the file in excel but it was too big to attache? Do you just need the excel list file?

  6. #6
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need folders copies into other folders based on excel list

    Example File2.xlsx
    here is the excel file

  7. #7
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Need folders copies into other folders based on excel list

    are job folders and part number folders in the same folder ?

  8. #8
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need folders copies into other folders based on excel list

    No they are in different folders, but could be combined it that helps.

  9. #9
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Need folders copies into other folders based on excel list

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    07-29-2013
    Location
    Portland Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need folders copies into other folders based on excel list

    patel45,

    Just wanted to thank you for the code. It took some time to get back to this project and I am glad to say it worked great!

    I really appreciate your help!

    Thanks!

+ 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. Replies: 0
    Last Post: 12-04-2012, 01:01 PM
  2. Arrange or group folders based on the assigned icons to Folders using vba
    By sanits591 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2011, 02:04 AM
  3. 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
  4. Probems putting folders into other folders based on user input.
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-16-2010, 12:16 PM
  5. Making folders based on list of names
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2005, 06:20 AM

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