Keeping whole formula constant to new workbook

  • Thread starter Thread starter Hamed parhizkar
  • Start date Start date
H

Hamed parhizkar

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???
 
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
 
Back
Top