Search Multiple Workbooks Possible?

[Gerard Sanchez]

Hi,

Right now in my company, oddly enough, we have lots of workbooks with only
one worksheet in it (I know, know, . . not particularly the best way to go
about it. But since I have to work with these files, other than merging the
worksheets into one workbook, is there another way where I can search
multiple workbooks all one once?

Thanks

 

[Ron de Bruin]

Hi Gerard

Merge the workbooks
Try this add-in
http://www.rondebruin.nl/merge.htm

 

[Gerard Sanchez]

so I guess there really is no way of searching different workbooks all at
one?

 

[Ron de Bruin]

Hi Gerard

You can creata a macro that open workbooks and search
in each workbook but not in a normal way.