View Single Post
  #1   Report Post  
Boz
 
Posts: n/a
Default copying formulas

What is the easiest way to copy formulas?

Basically I have a sheet that refers to set values per section which act as
a multiplier so I have a function that says '=(a4 * a2)' next one should be
'=(a5 * a2)' and so on. When I paste the formula in it goes to '=(a5 * a3)'.

Is there an easy way to remedy this situation?