| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping whole formula constant to new workbook
If i have a formula in workbook "HOME". For example the formula is =sum(a1+b1).
If I copy the whole page and paste it into a new workbook named "HOUSE" the formula comes over as ='HOME'(a1+b1) What could I do to make the formula stay the same regardless of what workbook it was on??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping whole formula constant to new workbook
Open House and Home
Use Windows | Arrange and tile them side by side Hold down the CTRL button and drag the tab of the Home sheet to the tab list on the HOUSE file best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Hamed parhizkar" wrote in message ... If i have a formula in workbook "HOME". For example the formula is =sum(a1+b1). If I copy the whole page and paste it into a new workbook named "HOUSE" the formula comes over as ='HOME'(a1+b1) What could I do to make the formula stay the same regardless of what workbook it was on??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping same-row(or column) cell constant in a formula while drag- | Excel Worksheet Functions | |||
| Keeping Formula variable constant when adding new column | Excel Discussion (Misc queries) | |||
| Keeping # of Cells constant in a formula | Excel Worksheet Functions | |||
| Keeping the column constant in a formula | Excel Discussion (Misc queries) | |||
| Keeping cell references constant | Excel Discussion (Misc queries) | |||
Linear Mode
