Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding Data in multiple worksheets
Using Excel 2000, how can I find data in multiple worksheets; example:
any number between 200 & 299 in 32 worksheets? |
#2
|
|||
|
|||
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. " wrote: Using Excel 2000, how can I find data in multiple worksheets; example: any number between 200 & 299 in 32 worksheets? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
Merge Data From Multiple Worksheets | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |