scotsrule08
New Member
- Joined
- Jun 21, 2018
- Messages
- 45
Good day fellow Mr Excel Experts!
I have a folder with hundreds of spreadsheets. I need to identify any spreadsheet with the value $493 in column B. There is not a specific cell that 493 would be in, and not every spreadsheet has 493 in column B.
I jut need a list with the file name of any spreadsheet with the value 493 somewhere in column B.
There will be many other values in column B besides 493.
any help is appreciated!
Thank you!
I have a folder with hundreds of spreadsheets. I need to identify any spreadsheet with the value $493 in column B. There is not a specific cell that 493 would be in, and not every spreadsheet has 493 in column B.
I jut need a list with the file name of any spreadsheet with the value 493 somewhere in column B.
There will be many other values in column B besides 493.
any help is appreciated!
Thank you!