Search for a file - Excel

[bnc123]

I have a directory full of Excel files. All the files are of the same format.

I want to look for a file (spreadsheet) that has the number (not text) 9.543 in cell D10.

Is there a search utility that allows me to do something like that? I can't seem to do it with conventional search utilities.

 

[xlbo]

nope - not without utilising some programming in excel

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question