Find in multiple worksheets

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

(Excel 2000).

Is there a way to search 53 worksheets to find which one
has a particular value?
 
Andy,

The "master" worksheet contains 3,000 records. Each record
is also contained in one of 53 smaller worksheets.

I need to move each record from the "master" worksheet to
the smaller worksheet that contains the matching record.

How do I find which smaller worksheet contains the
matching record?

(When using FlexFind, I have opened the "master" worksheet
plus the 53 smaller worksheets. But FlexFind only looks
in the "master" worksheet, not in the smaller worksheets).

Gary
 
Gary

Flexfind will find across all worksheets if you tell it to.

When you open Flexfind note on right-side "look in". Check "workbook" not
"sheet".

Gord Dibben Excel MVP
 
Back
Top