Finding amounts on different worksheets

[Caught]

Help please .....

I have been given the task of keeping the accounts [on excel] in order. The
business has the sales client name and figures listed per month on different
worksheets.

When a payment comes in for a specific amount, it would be very useful to go
to a function that could search every worksheet. [All I seem to be able to
do is the methodically do a 'find' on every worksheet]

Is there any way in which the FIND can be used to search every worksheet?

 

[Don Guillett]

try
right click on sheet tab>select all sheets>edit>find>joe prospect>values

 

[Caught]

Pretty ancient Version ...

Version 8 - Created 21.11.96 ..... it came with Office 97

Sadly it does not have that feature :-(

Look like I may be stuck

try
right click on sheet tab>select all sheets>edit>find>joe prospect>values

--
Don Guillett
SalesAid Software
(e-mail address removed)

Help please .....

I have been given the task of keeping the accounts [on excel] in order.
The business has the sales client name and figures listed per month on
different worksheets.

When a payment comes in for a specific amount, it would be very useful to
go to a function that could search every worksheet. [All I seem to be
able to do is the methodically do a 'find' on every worksheet]

Is there any way in which the FIND can be used to search every worksheet?