Macro to find files in directory and copy data from specific cells to this worksheet

**oksox** · 02-22-2019, 07:30 PM

Please help, I'm total noob with vba. Here is what I would like to do. I have a summary file that I use to check the status of projects in other files. Here is what I would like to do:
1. create a macro that will loop through the list of files
2. find each file in the directory based on a partial name
3. Copy data from a specific cell from each file and past in the master list.
4. there is data in the cell already to skip and loop to the next file.

Below is a crude example of the check summary list where the data should be pasted.

Any help would be greatly appreciated.

list.PNG

**JLGWhiz** · 02-22-2019, 07:52 PM

Hi oksox, welcome to the forum. There are lots of members who would be willing to help you, but you post is missing information that is essential to writing a workable code. Here is what you need to provide.
1. If the target files are in a different directory than your summary file, lisit the directory path.
2. Specify what the partial file name is that you want to search for. eg. "Checklist"
3. If there is a possibility that the same file could be in the directory with different file extenstions, i.e. xlsx and xlsm, then specify the file extensions for the files you want.
4. If you want to copy a specific range, specify the sheet name and range address, eg. Sheet 1, A2:Z20 or Columns C and D.
5. Specify the destination for the copied data.
6. If merged cells are in the data range to be copied, you might need to unmerge them for the code to run properly.

That should be a good start for getting someone to suggest some code for you.

Macro to find files in directory and copy data from specific cells to this worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to find files in directory and copy data from specific cells to this worksheet

Re: Macro to find files in directory and copy data from specific cells to this worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] macro to copy excel files only from main directory and sub directory to a specific folder

Loop through all .xlsx files in directory and copy data in those files into a new file

[SOLVED] Copy specific files from one directory to another

Macro to find specific text within directory XLS files and output data to new worksheet

macro to copy a specific worksheet from all open files into one file

Copy selected files into a specific directory

Bookmarks

Bookmarks

Posting Permissions