Formula to move x columns along

[dave1983]

Good Afternoon

I am setting up a sheet for next year and it looks at weekly data.

The first formula I have in place in column A is this

Please Login or Register  to view this content.

I want column B to be

Please Login or Register  to view this content.

And then column C to be

Please Login or Register  to view this content.

So basically I need the formula to look at the row 7 columns on from the last but I have to do this for the whole year and that will take ages!!!!

Is there any way I can do this or would it have to be a macro

[ragulduy]

I think something like:
=OFFSET('[Forecast 2014.xlsx]Daily Actual 2014'!C5,0,6*(COLUMN(A1)-1))

[XOR LX]

Hi,

=INDEX('[Forecast 2014.xlsx]Daily Actual 2014'!5:5,,7*(COLUMNS($A:A)-1)+3)

Regards

[:) Sixthsense :)]

Try this...

In Column-A

=INDEX('[Forecast 2014.xlsx]Daily Actual 2014'!5:5,(COLUMN(A1)-1)*7+3)

Drag it to right...

[dave1983]

wow that was fast thanks for all the responses.

[dave1983]

Sorry I have just realised an error with my request.

For the first 5 occasions i need the fromula to look at the column 7 columns on from the previous one so i used the formula as above

Please Login or Register  to view this content.

but on the 6 occasion i want it to look at the 6th column along and then repeat this for the rest of the year.

[XOR LX]

Hi,

It's not clear how the very first formula (which looks at C5) is to fit into these groups. Could you clarify by, again, manually listing the intended cell references, including those new ones, e.g. C5, J5, Q5, etc. but this time to the very end?

Regards

[dave1983]

Hi yeah sorry about that so this is how i want it to go

the current formula works fine for the first instances so I have

Please Login or Register  to view this content.

With this fromula in place in cell in C4 i correctly referenced Column C and row 5 in the master forecast sheet

By dragging the formula to the right I was then able to refference the next cell i wanted which was column J and again row 5

basically I repeat this process 4 times so i have the formula looking at

C5 then J5 then Q5 then X5 then AE5 in the other sheet, from this next column on though I need to be looking at every column 6 along from the last so in essence i want to be looking at

cell AK5 and then AQ5 and then AW5 so on and so forth

I hope this makes a bit more sense.

[SDCh]

May be with change this part

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

[dave1983]

thats perfect.

Thank You very much