Keeping whole formula constant to new workbook

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???
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compatability issue 1
Re problem with getting formula in workbook 3
Named Formula across multiple worksheets 4
Constant date in one cell 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
Add to an Existing formula in a Cell using VBA 1
copy WB without VBA: copied sheets link back to source WB 2
HELP!!! I can't set formula to cell 1

Top