Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
I'm not sure if this should be here or probably in the VBA section.
Is there an easy way to look for a term, specifically a part#, in multiple files?
The part# may not be the only information in a specific cell, and may not be in the same range on each sheet.
I have multiple workbooks, each with 1 sheet.
I am in need of finding all my files that contain a specific part#.
So I would like to generate a list of file names if the file contains my part#.
Thank you,
Simi
Is there an easy way to look for a term, specifically a part#, in multiple files?
The part# may not be the only information in a specific cell, and may not be in the same range on each sheet.
I have multiple workbooks, each with 1 sheet.
I am in need of finding all my files that contain a specific part#.
So I would like to generate a list of file names if the file contains my part#.
Thank you,
Simi