+ Reply to Thread
Results 1 to 3 of 3

Macro to Copy Data from Folders Listed in Col A and Paste in folders listed in Col B

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,727

    Macro to Copy Data from Folders Listed in Col A and Paste in folders listed in Col B

    I have folders listed in Coll A on sheet "Folders" I have tried to write VBA Code to copy the workbooks listed in these folders and paste these in the folders listed in Col B on sheet "Folders

    When running the code the workbooks are not being copied and pasted


    Kindly check my code and amend accordingly




    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-16-2023
    Location
    Poland
    MS-Off Ver
    Excel 2019 32bit WIN10
    Posts
    88

    Re: Macro to Copy Data from Folders Listed in Col A and Paste in folders listed in Col B

    Check this:
    Please Login or Register  to view this content.
    Last edited by Tajan; 11-02-2023 at 06:20 AM.

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,727

    Re: Macro to Copy Data from Folders Listed in Col A and Paste in folders listed in Col B

    Thanks Tajan. This works perfectly and copies very fast

+ 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. Macro to create Email and attach files listed within Sub-Folders
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2023, 12:49 PM
  2. Replies: 2
    Last Post: 09-02-2022, 10:32 PM
  3. VBA code to move listed folders (and their contents) from one location to another
    By Lorietta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2020, 08:11 PM
  4. Folders name of X Drive listed on Excel
    By waqarqrl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2015, 05:43 AM
  5. Replies: 4
    Last Post: 03-31-2015, 11:40 AM
  6. [SOLVED] VBA to create Folders listed in column and in specified path refered in cell
    By Harish Kumar M in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2014, 01:27 PM
  7. Replies: 0
    Last Post: 05-26-2014, 07:47 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