Copying Formulas Between Worksheets

[Railrd]

Have two worksheets. On sheet 1 in cell D48 have the following formula:

=SUM((D9>C9), (F9>E9), (R9>Q9), (Z9>Y9), (AD9>AC9), (AF9>AE9), (AH9>AG9),
(AN9>AM9), (AP9>AO9), (AR9>AQ9), (AX9>AW9), (BB9>BA9), (BD9>BC9), (BF9>BE9),
(BN9>BM9), (O3>P3), (O4>P4), (O10>P10), (O14>P14), (O16>P16), (O17>P17),
(O18>P18), (O21>P21), (O22>P22), (O23>P23), (O26>P26), (O28>P28), (O29>P29),
(O30>P30), (O34>P34))

I would like to move it to a cell in sheet 2 but is there a way yo do this
quickly so I don't have to insert 'Sheet 1'! in front of every cell used in
the formula. It wouldn't be bad but I have to move about fifteen or so
formulas with various amount of variables (cells).

 

[Bernard Liengme]

In a brief experiment, this worked for me:
Copy the range having the data to Sheet2
Now copy the formulas to Sheet2
Finally Cut and Paste the Data from Sheet2 back to Sheet1
best wishes & Merry Christmas

 

[Ragdyer]

One way would be to leave the formulas in Sheet1 and just *link* to them in
Sheet2.

Say you want this in D48 of Sheet2.

Enter an equal sign ( = ) in D48 of Sheet2.
Navigate to, and click in, D48 of Sheet1, and hit <Enter>.

If you want, you can move the Sheet2 formula to an out-of-the-way location
on Sheet2, and just link Sheet1 to the new location on Sheet2.