Hi all

Seems a problem with the search function

I hope there is a simple answer to this

I have 2 workbooks. In workbook 1 there are 2 sheets. I have a formula on sheet 1 cell a1 that adds together the data in sheet 2 cells A1 and B1

Now when i copy this formula to workbook 2, it automaticaly references to the cells on sheet 2 workbook 1

How can i keep the syntax of the formula so it references sheet 2 on workbook 2?

Thanks