Hi,

Because you do not mention what version of Excel you are using or if you
mean all 15 workisheetss are in 1 workbook I'm going to assume that you are
using Excel version 2003 and all 15 worksheets are in 1 workbook. You would:

1. Right click on any of the worksheet tabs.
2. Pick "Select All Sheets" from the drop down menu.
3. Select Edit from the menu bar.
4. Select Find and then a case number.

You should be able to find any case number you wish, but you must have all
of the worksheets selected in the workbook. If the data is in 15 separate
workbooks you will have to open each individually. Again, with the info you
provided this is my best solution. PLEASE presee Yes if this helped.

JCS



"em" wrote:

Is it possible to do a 'find' of a series of numbers (not within a range) eg.
case numbers? I am wanting to look up about 150 individual cases yet don't
want to have to find them individually within the 15 worksheets where they
are currently hiding.
Please help???