Copying Formulas Between Worksheets
 

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

=SUM((D9C9), (F9E9), (R9Q9), (Z9Y9), (AD9AC9), (AF9AE9), (AH9AG9),
(AN9AM9), (AP9AO9), (AR9AQ9), (AX9AW9), (BB9BA9), (BD9BC9), (BF9BE9),
(BN9BM9), (O3P3), (O4P4), (O10P10), (O14P14), (O16P16), (O17P17),
(O18P18), (O21P21), (O22P22), (O23P23), (O26P26), (O28P28), (O29P29),
(O30P30), (O34P34))

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).

Copying Formulas Between Worksheets
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Railrd" wrote in message
...
Have two worksheets. On sheet 1 in cell D48 have the following formula:

=SUM((D9C9), (F9E9), (R9Q9), (Z9Y9), (AD9AC9), (AF9AE9), (AH9AG9),
(AN9AM9), (AP9AO9), (AR9AQ9), (AX9AW9), (BB9BA9), (BD9BC9),
(BF9BE9),
(BN9BM9), (O3P3), (O4P4), (O10P10), (O14P14), (O16P16), (O17P17),
(O18P18), (O21P21), (O22P22), (O23P23), (O26P26), (O28P28),
(O29P29),
(O30P30), (O34P34))

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).

Copying Formulas Between Worksheets
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Railrd" wrote in message
...
Have two worksheets. On sheet 1 in cell D48 have the following formula:

=SUM((D9C9), (F9E9), (R9Q9), (Z9Y9), (AD9AC9), (AF9AE9), (AH9AG9),
(AN9AM9), (AP9AO9), (AR9AQ9), (AX9AW9), (BB9BA9), (BD9BC9),
(BF9BE9),
(BN9BM9), (O3P3), (O4P4), (O10P10), (O14P14), (O16P16), (O17P17),
(O18P18), (O21P21), (O22P22), (O23P23), (O26P26), (O28P28),
(O29P29),
(O30P30), (O34P34))

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).