Hello,

I have a workbook (lets call it WB1) with two sheets. In Sheet X I have some formulas that refers to cells in Sheet B.

I want to copy the entire Sheet A to another workbook (called WB2). In the new workbook I want the fomulas to link to cells in Sheet B for WB2.

But if I copy the formulas from WB1, Sheet X and paste them in a new sheet in WB2 the all refer back to WB1.

Thanks in advance

Vic