Search accross Multiple files

  • Thread starter Thread starter student
  • Start date Start date
S

student

Hi,

Can i do a search in multiple files. The data is stored in Multiple files
because the there are about 17000 records.

thanks
 
You can search across multiple worksheets in the same file quite easily
(right click one of the sheet tabs at the bottom and select all then do a
find as usual) so you could move all of your records into one file on
multiple sheets.

If there are only 17,000 records there should be no problems using one sheet
for all of the records in later versions of excel though.

Duncan
http://www.excel.duncan-fiona.co.uk
 
Thanks very much Duncan. I Appreciate that. I hoped that could have been
Possible.
Actually it is 170000, sorry for missing zero.

Thanks
 
Back
Top