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!