How to search a directory and return results

August 28, 2017 at 11:38:36
Specs: Windows 7
We repair devices and keep track of all repairs made. Each month has its own Excel file stored in a common directory. There is a sheet in each Excel file for the different devices. The SN, date, failure, and a couple other things are recorded for each repair that is made. I would like to create a macro that will search that directory and find all instances of an inputted serial number, (in all files and sheets) copy the B,C,H, and I columns and list them out in the sheet. Creating a history of the serial number in question.

See More: How to search a directory and return results

Reply ↓  Report •

#1
August 29, 2017 at 00:31:44
How are the sheets named in the workbook, are they named using the serial number?

Or

Which columns are the serial numbers recorded in?

This will help with the search feature otherwise we will have to search every sheet and every column which will slow things down.

Will the serial number only appear in ONE sheet of ONE workbook?


Reply ↓  Report •
Related Solutions


Ask Question