Copy specific cells from many files into master file

**cmgst49** · 10-03-2012, 01:12 PM

Hello,
I have about 100 files in a single folder, all made from a single template. I would like to pull information from these files into a single master file. The problem is that I dont want all the data from each spreadsheet, only specific cells. For example, I would like to pull cells I9, F4, F5, and K3 from each file, and then paste them into a new file in cells B3,C3,D3,E3. Then take the same cells from the next file,and put them in cells B4,C4,D4,E4.
Any thoughts on how to do this?
Thanks in advance!

**Chippy** · 10-03-2012, 02:31 PM

Try this code in the master workbook, which you should save in a folder separate to the folder containing the 100 files. You will need to edit the code where shown to change the folder path containing the 100 files. It opens all files matching *.xls in that folder, which you may need to change to *.xlsx or *.xslm, etc. depending on what the file extension of the 100 files is.

Please Login or Register  to view this content.

**cmgst49** · 10-03-2012, 03:05 PM

This is EXACTLY what I needed. I made a few simple mods to make add more cells to the mix. My friend, you are a genius.

Copy specific cells from many files into master file

LinkBack

Thread Tools

Rate This Thread

Display

Copy specific cells from many files into master file

Re: Copy specific cells from many files into master file

Re: Copy specific cells from many files into master file

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions