Global Calculation ???

C

Cowtoon

Using Excel 97

I have a number of spreadsheets where I have to do a convert all amounts
with a calculation. Is there a global way to do this. There's quite a few
cells and spreadsheets ... would be nice to not have to tell each cell to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana
 
K

Kassie

Hi

Do you want to apply the same formula to these cells, or what? You can make
use of a macro to achieve your goal, but the macro itself will be difficult
to write without any guidelines?
 
C

Cowtoon

Thanks for responding Kassie.
Fortunately, yes ... it is the same for all. It's a conversion for all
values from $C to $US (if that helps).

It would be great if this can be with less steps that what I described in my
original post
Diana.
 
P

Peo Sjoblom

Put the rate in an empty cell (today's rate is 0.849894), copy it and select
all values,
do edit>paste special and select multiply. I would probably make a copy of
your worksheet first just in case you make a typo

--
Regards,

Peo Sjoblom

(No private emails please)
 
C

Cowtoon

Thank you so much Peo. I appreciate the response.
This will save me tons of time.
Diana
 
Top