Search Multiple Workbooks Possible?

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
G

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
 
so I guess there really is no way of searching different workbooks all at
one?
 
Hi Gerard

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