Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Searching Between Worksheets

Jun 1, 2004 2:15AM PDT

I am currently trying to search between two Excel Worksheets to match data that may have been entered incorrectly. How can I search partially between the two worksheets to find possible matches? I have a list of about 1000 data sets that I am trying to find matches to. Any help on searching between these two worksheets quickly?

Thanks

Discussion is locked

- Collapse -
Re:Searching Between Worksheets
Jun 1, 2004 3:50AM PDT

I assume you know very well what you want, but I, for one, don't understand it at all.
You've got two worksheets (in the same xls-file?) and you want to compare/search for something between worksheets, that's what I make of it. Please describe your application, and provide an example.

Kees

- Collapse -
Re:Searching Between Worksheets
Jun 1, 2004 12:22PM PDT

As you may already know, you can search through multiple worksheets by merely highlighting the associated worksheet tabs before you start your search. Also, you can use this with Replacing also.

However, that was my first reaction to your post before I finished it-

"I have a list of about 1000 data sets that I am trying to find matches to."

THAT is a problem in another league and you might need to provide some more information, such as, what sort of data- text or values? Which version of Excel, etc.

Moreover, how do you plan to realistically deal with this problem once you have located the faulty data?