Finding amounts on different worksheets

C

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?
 
C

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


Don Guillett said:
try
right click on sheet tab>select all sheets>edit>find>joe prospect>values

--
Don Guillett
SalesAid Software
[email protected]
Caught said:
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?
Click to expand...
Click to expand...
 
Top