Cell Referencing

[Aidy]

Is there any way of referencing every other column, to each row in a
another spreadsheet without hard-coding it?


E.g.

We want cells A1, A2, A3 ... in sheet 2, to contain, the values of
cells B1,
D1, F1 ... in sheet 1.

Aidy

 

[JE McGimpsey]

One way:

in sheet2:

A1: =INDEX(Sheet1!$1:$1,ROW()*2)

copy down.

 

[Max]

One way ..

In Sheet2

 

[Max]

oops, slight correction to formula ..

Line

Put in A1: =OFFSET(Sheet1!$A$1,0,ROW())

should read: