# Thread: Copy formula over eight columns Thanks: 0 Likes: 0

1. ## Copy formula over eight columns

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
.

2. ## Re: Copy formula over eight columns

Welcome to the Board!

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)?

3. ## Re: Copy formula over eight columns

I guess you have the formulas in C and in K, try this

 A B C K 1 2 3 5

 Cell Formula C2 =(OFFSET(Actual!\$C170,,MOD(COLUMN()+5,7)-1) + OFFSET(Actual!\$C174,,MOD(COLUMN()+5,7)-1)) / Summary!H10 K2 =(OFFSET(Actual!\$C170,,MOD(COLUMN()+5,7)-1) + OFFSET(Actual!\$C174,,MOD(COLUMN()+5,7)-1)) / Summary!P10

In the formula of cell K2 you see \$ C, but you're really getting the value from column D

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•