Copy formula over eight columns

New Member

I a worksheet that I am comparing Actua,Budget, Forecast, and PY for each day of he month. I have the raw data for each in it's own tab. I have the below formula that I need to copy over eight columns each time, thus when I copy over eight columns it changes the C to K but I want it to change to D instead and so forth.
(Actual!C170+Actual!C174)/Summary!H10
.

MrExcel MVP, Junior Admin

I don't think your question is entirely clear. Maybe it will make more sense if you walk us through some examples, i.e.
- What cell is the original formula in?
- What does the original formula look like?
- What cell should the formula be copied to?
- What should the formula look like after being copied to this cell?
- How many times does this need to be copied (how do we know when to stop)?