Simple way to add a reference to a cell
 

I have a number of estimates across 3 seperate worksheets. I would like to
be able to multiply each of these numbers by referring them to a specific
cell whose value I can change. However, I don't want to have to go to each
seperate cell and retype the original number and then add the reference
cell. For example, if I have the numbers 100, 200, 300 in seperate cells
and want to multiply each of these numbers by the number in cell A1, is
there a way to add *A1 to each of the cells without having to retype in each
individual cell?

Simple way to add a reference to a cell
 

in a2 to a10: -- 1000
in a1: -- 10
copy a1
select a2:a1000
paste special/multiply

....Patrick

"synapse" a écrit dans le message de
news:rlsVc.36011$X12.8776@edtnps84...
I have a number of estimates across 3 seperate worksheets. I would like
to
be able to multiply each of these numbers by referring them to a specific
cell whose value I can change. However, I don't want to have to go to
each
seperate cell and retype the original number and then add the reference
cell. For example, if I have the numbers 100, 200, 300 in seperate cells
and want to multiply each of these numbers by the number in cell A1, is
there a way to add *A1 to each of the cells without having to retype in
each
individual cell?