acarterczyz
New Member
- Joined
- Jan 4, 2013
- Messages
- 21
Hey guys,
I'm trying to create a macro in Excel that will search all files in a specified folder. There are about 90 files (all with the same header) and have 100,000+ rows. What I need it to do is basically allow me to specify the header and criteria on Sheet1 and search through all files for anything that matches that criteria and pastes it to Sheet2.
I currently have a macro that opens all the files in the folder (and converts them to binary), but I don't know how to get them to copy matching criteria over to Sheet2.
Any help would be MUCH appreciated!
Edit:
This is what Sheet1 looks like.
I'm trying to create a macro in Excel that will search all files in a specified folder. There are about 90 files (all with the same header) and have 100,000+ rows. What I need it to do is basically allow me to specify the header and criteria on Sheet1 and search through all files for anything that matches that criteria and pastes it to Sheet2.
I currently have a macro that opens all the files in the folder (and converts them to binary), but I don't know how to get them to copy matching criteria over to Sheet2.
Any help would be MUCH appreciated!
Edit:
This is what Sheet1 looks like.
Last edited:
