Finding a specific piece of data across many workheets in a workbook

[Guest]

I have a series of worksheets within a workbook (i.e. Jan 04, Feb 04 Mar 04) with sales for each month listed as follows
Purchae order (PO) Date, PO number, Customer, Manufacturer, PO amount, Invoice number
Is there a way to have Excel look in all of the worksheets for a specific invoice number other than using the "find" feature worksheet by worksheet?

 

[Ken Wright]

In the options menu you may find that you can specify entire workbook as the
search target - Depends on your version of Excel.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have a series of worksheets within a workbook (i.e. Jan 04, Feb 04 Mar 04)

with sales for each month listed as follows;

Purchae order (PO) Date, PO number, Customer, Manufacturer, PO amount, Invoice number.
Is there a way to have Excel look in all of the worksheets for a specific

invoice number other than using the "find" feature worksheet by worksheet?

 

[Gord Dibben]

Version 97 does a bad job of finding across worksheets.

2002 and 2003 are OK with this feature.

Gord Dibben Excel MVP

 

[Dave Peterson]

you can use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/