This may be easier for you.

Copy the formula from one sheet to another. Don't copy the cell!!
Select the cell with the formula you want. In the formula line up top
highlight the entire formula with the = sign, right click and copy. Remove
the highlight before switching sheets, go to the end and then hit enter. This
will keep your formula on the first in tact.
Now bring up the sheet that you want ot copy the formula to and select the
cell you deisre. In the formula bar right click and paste or CTRL+V
Now all you have to do is place you cursor in the formula over each cell or
that WAS refernced and change it to the cell you want to reference on the new
sheet

For example lets say this is you formula on sheet 1

=(D2*E2)/G3

When you copy that to sheet 2 and if your reference cells are different,
lets say D5,E5 and G6 then you would have this
=(D5*E5)/G6

HTH

Neil M

Thanks for this solution, so simple and it works!

"Neil M" wrote:

This may be easier for you.

Copy the formula from one sheet to another. Don't copy the cell!!
Select the cell with the formula you want. In the formula line up top
highlight the entire formula with the = sign, right click and copy. Remove
the highlight before switching sheets, go to the end and then hit enter. This
will keep your formula on the first in tact.
Now bring up the sheet that you want ot copy the formula to and select the
cell you deisre. In the formula bar right click and paste or CTRL+V
Now all you have to do is place you cursor in the formula over each cell or
that WAS refernced and change it to the cell you want to reference on the new
sheet

For example lets say this is you formula on sheet 1

=(D2*E2)/G3

When you copy that to sheet 2 and if your reference cells are different,
lets say D5,E5 and G6 then you would have this
=(D5*E5)/G6

HTH

Neil M