+ Reply to Thread
Results 1 to 2 of 2

Copy paste and rename folder based on Cell values

  1. 08-28-2014, 04:52 AM #1
    BrettRogersUK is offline
    Registered User
    Join Date
    04-15-2013
    Location
    Idle, Bradford
    MS-Off Ver
    Excel 2010
    Posts
    1

    Copy paste and rename folder based on Cell values

    Hi All,

    I wonder if anyone can help me. I'm looking for some VBA code that will copy a folder I have set up as a template folder (with sub-folders), paste it to a new location and rename it based on a value in a cell multiple times.

    I would like the code to do this for each value in a cell range. so the operation would be copy folder->Paste folder->rename folder for each instance in the cell range.

    I have my list of folder names in range D3:D48.

    Is this at all possible?

    Thanks,

    Brett
    Reply With QuoteRegister To Reply
  2. 08-28-2014, 04:54 AM #2
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Copy paste and rename folder based on Cell values

    http://www.rondebruin.nl/win/s3/win026.htm

    About 528,000 results (0.36 seconds)

    http://www.excel-easy.com/vba/exampl...ned-range.html

    About 503,000 results (0.27 seconds)
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. search for a file in a folder based on data, copy and paste it in another folder
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 11:47 AM
  2. Copy and Paste columns based on cell values
    By devin1428 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2012, 07:50 AM
  3. Copy and Paste values based on another cell
    By clc3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2012, 05:15 PM
  4. Copy and Paste (Same worksheet) based on cell values
    By muckem333 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2011, 04:43 PM
  5. Copy Rows and Paste Based On Cell Values
    By boohah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2010, 08:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1