View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
synapse synapse is offline
external usenet poster
 
Posts: 1
Default 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?