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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Search for text (across multiple worksheets) in Excel 2007? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Require formula to search across multiple worksheets 2
How do I search multiple worksheets silmutaneously in Excel? 4
Unhide multiple worksheets in workbook 2
Repeat printing rows in multiple worksheets 19
replace all formulas with values in multiple worksheets 5

Back
Top