How to copy sheet and keep references to that sheet?

**the-trooper** · 07-28-2014, 08:27 AM

Hello everyone
Copy "SheetA", and you get "Sheet A (2)". But i want all of the formulas in second, just copied, sheet to reference first one. So what in "SheetA" was =W1 in "Sheet A (2)" should be =SheetA!W1. Is this posible?

If not, is there any easy way to add a prefix to selected range of formulas. I tried Find/Replace, but it ignores the formula and i end up with just a plane piece of text.

Thanks in advance!

**Special-K** · 07-28-2014, 08:30 AM

You MAY be able to use Find/Replace, replacing all = to =SheetA! depending on the formulas.

**the-trooper** · 07-28-2014, 08:42 AM

Originally Posted by Special-K

You MAY be able to use Find/Replace, replacing all = to =SheetA! depending on the formulas.

I tried it, it works if you click "Replace", and keep on clicking it to replace all of them. But if you click "Replace all" i get "formula contains error bla bla bla...". Strange.

EDIT: you were right if it's a simple =W1, then it works, but anything else fails, obviously. So Find/Replace works only for =cell number.