Copy paste

[Kim B]

Hi all. I have a workbook with 2 sheets. Sheet1 has data, sheet 2 is a simple sum formula adding two cells together. I want to copy the formula in Sheet 2 across and down. There is a formula in every 3rd column so when try and copy the formula across, it skips rows.

Sheet 1

Sheet 2

 

[Kim B]

Bump

 

[Skrej]

It looks like every third column on sheet1 has a formula summing the previous two columns? If so, try pasting this in cell a1 on sheet 2, and copying across:

=OFFSET(Sheet1!$A$1,0,(COLUMN(A1)*3)-1)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Kim B]

This tab is called deli

deli
This is called Forecast

forecast
The offset formula you provided (tweaked for the cell references) works for the first cell reference but then jumps columns. The cells in the forecast sheet need to reference the cells in deli sheet but the forecast sheet has third column to every two days for a variance. So 12/31 and 1/4 ae ok, but then 1/2 jumps to 1/3

 

[Fluff]

How about

=INDEX(deli!C4:AJ100,XMATCH(B4,deli!B4:B100),XMATCH(C2,deli!C2:AJ2))