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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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 :-)
----------------------------------------------------------------------------



Rickl138 said:
I have a series of worksheets within a workbook (i.e. Jan 04, Feb 04 Mar 04)
Click to expand...
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
Click to expand...
invoice number other than using the "find" feature worksheet by worksheet?
 
Version 97 does a bad job of finding across worksheets.

2002 and 2003 are OK with this feature.

Gord Dibben Excel MVP
 
Back
Top