Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Worksheets | Excel Worksheet Functions | |||
Copying Formulas to Other Worksheets | Excel Worksheet Functions | |||
Copying formulas from multiple worksheets | Excel Worksheet Functions | |||
Shortcut for copying formulas referencing different worksheets | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) |