Hi Gord,
I am analising telephone data to establish links between one subscriber in
respect of whom all their calls for a given period are input into a
worksheet, and numbers of other individuals. This means checking within the
worksheet for any of 100 other numbers. Having identified such calls, then I
create additional worksheets to show the links.
What I am seeking is a way of searching within the worksheet for the "100"
numbers. I am currently using find for each number which is taking a loing
time.
Whjat I am asking is whether it is possible to "search" on several of the
numbers at any one time and thereby reduce my time.
I agree that using the filter does assist, but only when an idenftified
number is found. It is then possible to identify all calls made by that
number within the period.

If this is not clear please let me know and I will try and elobarate further
In the meantime, thanks for your response.

Kind regards,

TW

"Gord Dibben" wrote:

Your "document" is an Excel workbook with multiple worksheets?

What type of multiple searches do you need?

On each sheet you could use an Autofilter to filter for a number or groups of
numbers withing a range of numbers.

EditFind will work across multiple sheets.

EditFind will not work across separate workbooks.

More detail might allow for a less generic answer.


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 11:14:03 -0700, Willsecur
wrote:

I have created a worksheet containing a large number of telephone numbers -
other than using find, is there a way of conducting multiple searches within
a document or gorup of documents?

Thanks,

TW