Using the "Find" option across multiple tabs in one worksheet

[Guest]

In Excel, I have 144 tabs within the same worksheet. I need to use the Edit

Find option to find a specific product id within each worksheet. For an

example, product ID: ABC. How can I use the "Find" option across all tabs at
the same time? Thanks

 

[Bob Umlas]

Click Options, then change "Sheet" to "Workbook"

In Excel, I have 144 tabs within the same worksheet. I need to use the
Edit
example, product ID: ABC. How can I use the "Find" option across all tabs
at
the same time? Thanks

 

[Dave Peterson]

You could also use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

(The feature that Bob suggested was added in xl2002, IIRC.)