Finding Data in multiple worksheets

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Using Excel 2000, how can I find data in multiple worksheets; example:
any number between 200 & 299 in 32 worksheets?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto update to multiple worksheets 2
Sorting in multiple worksheets 1
Cannot copy worksheet to another file 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Search for text (across multiple worksheets) in Excel 2007? 1
Graphing data from multiple worksheets in same workbook 1
How to use multiple command button to copy user form data to multiple worksheet 0
How do I import data from a text file into Excel 2003 2

Back
Top