macro to copy workbooks from Folder into the appropriate sub-folder

**Howardc1001** · 07-12-2021, 10:43 AM

i have workbook where I list the workbook, Folder and sub-folders

I would like a macro to copy the workbooks from the specified folder into the appropriate sub-folder.

I there is no workbook , the it will be indicated in Workookm as yes or No to copy

It would be appreciated if someone can provide me with the code to do this

**PCI** · 07-12-2021, 04:14 PM

See next code

Please Login or Register  to view this content.

**Howardc1001** · 07-12-2021, 10:58 PM

Many thanks for the help. Have tested your code and it works perfectly

**PCI** · 07-13-2021, 02:24 AM

Good day.
Enjoy Excel

macro to copy workbooks from Folder into the appropriate sub-folder

LinkBack

Thread Tools

Rate This Thread

Display

macro to copy workbooks from Folder into the appropriate sub-folder

Re: macro to copy workbooks from Folder into the appropriate sub-folder

Re: macro to copy workbooks from Folder into the appropriate sub-folder

Re: macro to copy workbooks from Folder into the appropriate sub-folder

Thread Information

Users Browsing this Thread

Similar Threads

Merging all workbooks in folder and moving to sub folder

[SOLVED] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?

Linking Two Workbooks in the Same Folder and Excluding the Folder Location

[SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new

create a compressed folder or zipped folder then copy workbooks to it.

copy all workbooks in a folder to a different workbook

Copy a cell to all workbooks within a folder.

Bookmarks

Bookmarks

Posting Permissions