is there a way to copy down and reference accross?

[Jeff131313]

i have series of headers in A1: z1 and on a seperate tab I want to reference vertically the order of values.

for example,
A6 = A1,
A7 = B1,
A8=C1,
A9=D1,
A10=E1
A11=F1
etc...

Can i copy this reference down vertically and continue the pattern of horizontal reference?

 

[schielrn]

Welcome to the Board!

Maybe:

=offset(a1,0,row(a1)-1)

Hope that helps.

 

[Jeff131313]

that worked! thank you!!

 

[T. Valko]

i have series of headers in A1: z1 and on a seperate tab I want to reference vertically the order of values.

for example,
A6 = A1,
A7 = B1,
A8=C1,
A9=D1,
A10=E1
A11=F1
etc...

Can i copy this reference down vertically and continue the pattern of horizontal reference?

Here's a non-volatile option...

=INDEX(Sheet1!A$1:Z$1,ROWS(A$6:A6))

Copy down as needed.