Problems copying a formula between worksheets

  • Thread starter Thread starter xin
  • Start date Start date
X

xin

I have two worksheets. Let's call them Book1 and Book2.

In cell A1 of Sheet1 of Book1, I have the following
formula:=Sheet2!A1.
When I copy this formula to Book2, the formula changes
to:=[Book1]Sheet2!A1.

Is there a way to copy this formula from Book1 to Book2 and have it
remain:=Sheet2!A1?

Thanks
 
Hi xin

You can use replace for this to make text of the formulas

Select the cells
Edit replace
Change = (equal sign) to $$$$$= (unique string).

Copy paste

Use Edit replace now to change $$$$$= to = to make formulas
 
Back
Top