is there a simple way to copy an exact formula from one cell to past on
another. for example in Cell E1 i have =SUM(A1:A10) , if I copy and paste in
to Cell F1 i get =SUM(B1:B10)

I understand if i lock the cells using $ sign or name the range it will have
the desired effect howvere I have about 200 or so to copy and paste (then
slightly modify the forluma )

Any help much appreciated.