Editing Formulas
 

I have used sheet names as part of my formula, however, I have other
sheets with the same design. I have made a copy of the sheet, but it
carries the original sheet name. Is there a way of using the find and
replace feature to change the sheet name in the formula e.g. sheet1!a10
to sheet2!a10

I have a large number of cells that require the sheet name to be
changed, hence my question. I hope someone has an answer.

Thanks


--
Tony_CC
------------------------------------------------------------------------
Tony_CC's Profile: http://www.excelforum.com/member.php...o&userid=35595
View this thread: http://www.excelforum.com/showthread...hreadid=553604

Editing Formulas
 

You don't need to include the sheetname in a formula if it refers to the
sheet that the formula ism on, if it doesn't, you would want the sheet name
to carry forward as is.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tony_CC" wrote in
message ...

I have used sheet names as part of my formula, however, I have other
sheets with the same design. I have made a copy of the sheet, but it
carries the original sheet name. Is there a way of using the find and
replace feature to change the sheet name in the formula e.g. sheet1!a10
to sheet2!a10

I have a large number of cells that require the sheet name to be
changed, hence my question. I hope someone has an answer.

Thanks


--
Tony_CC
------------------------------------------------------------------------
Tony_CC's Profile:
http://www.excelforum.com/member.php...o&userid=35595
View this thread: http://www.excelforum.com/showthread...hreadid=553604