Search accross Multiple files

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
 
D

Duncan Karran

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
 
S

student

Thanks very much Duncan. I Appreciate that. I hoped that could have been
Possible.
Actually it is 170000, sorry for missing zero.

Thanks
 
Top