Linking cells

[benwork]

Hey

Im having some difficulties linking cells between two sheets

I have data in Column A 1-100 in sheet1

I need to link that data into sheet2 but with A1 to link to A100, A2 to A200, A3 to A300 etc

Im trying to get a way just to drag the data down so I dont have to change each cell.

Thanks in advanced

Ben

 

[njimack]

=INDIRECT(ADDRESS(ROW()*100,COLUMN(),,,"Sheet2"))

 

[martindwilson]

=INDEX(Sheet2!A:A,ROW(A1)*100)

 

[T. Valko]

Hey

Im having some difficulties linking cells between two sheets

I have data in Column A 1-100 in sheet1

I need to link that data into sheet2 but with A1 to link to A100, A2 to A200, A3 to A300 etc

Im trying to get a way just to drag the data down so I dont have to change each cell.

Thanks in advanced

Ben

Try this...

=INDEX(Sheet1!A:A,ROWS(A$1:A1)*100)

 

[benwork]

Worked well

CHeers

 

[T. Valko]

Worked well

CHeers

You're welcome. Thanks for the feedback!