Finding Data in multiple worksheets

M

mark

Using Excel 2000, how can I find data in multiple worksheets; example:
any number between 200 & 299 in 32 worksheets?
 
D

Dave Peterson

If you mean you want to find a single number across 32 worksheets, group your
worksheets (click on the first, ctrl-click on subsequent (or even shift-click)).

Then Edit|Find

But I think I'd use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

If you meant you wanted to find all 100 numbers (200-299) in all 32 sheets, then
I think I'd have a macro search for each number and report the results on a new
worksheet.
 
Top