I've got the following 4 formulas in an excel wroksheet:

=SUM(E7/Sheet1!$B$3)*52 E7 = Feb $B$3 = 4

=SUM(D7+E7)/Sheet1!$C$3*52 D7+E7 = Jan + Feb $C$3 = 8

=SUM(D7+E7+F7)/Sheet1!$D$3*52 D7+E7+F7 = Jan+Feb+Mar $D$3 = 13

=SUM(P7/8)*52 P7 = YTD 8=number of accounting weeks thru Feb and 52 =
total weeks in a year.

I would like to create a macro in that all I would need to do is for example
change the E7 to an F7 and D7+E7 to E7+F7 in the macro instead of changing
them in the worksheet and copying and pasting.


Thanks.
--
Bob