Multiple Cell Editing...

[Twisty20]

This should be an easy one for you guru's:

I want to alter a formula in 10 cells, going down a column. Each one reads: =('NAME'!$F$#) , with the # being different numbers. Anyway, I want to alter all the cells to read: =('NAME'!$E$#)

I need a better way to alter them all at once, since going into each one is a pain. If there is a way to alter that one parameter (F --> E) in one shot without distracting the #'s, that would be great.

Thanks much!

[Bryan Hessey]

This should be an easy one for you guru's:

I want to alter a formula in 10 cells, going down a column. Each one reads: =('NAME'!$F$#) , with the # being different numbers. Anyway, I want to alter all the cells to read: =('NAME'!$E$#)

I need a better way to alter them all at once, since going into each one is a pain. If there is a way to alter that one parameter (F --> E) in one shot without distracting the #'s, that would be great.

Thanks much!

Tools,
Options,
View,
tick Formula
highlight the required cells
Edit
Replace
$E$
$F$
replace all

'OK"

then reset the 'View'
---

[Twisty20]

Bryan,

Once again, you have come to the rescue. Thank you, that works like a charm.

[Bryan Hessey]

Bryan,

Once again, you have come to the rescue. Thank you, that works like a charm.

Good to see, and thanks for the response
---