Referencing Relative and Absolute Cells between different sheets

[vbthedog]

Hi guys I have been stumbling around this for donkey's yonks and cannot quite get what I am after.

If I have Sheet 1 with Column E15 to E29 wanting values from Sheet 2 RowC6 > Q6 I know I am can copy and paste them manually as for example Summary E15 = Expenditure!C6 (with Expenditure being the Sheet Name). But how can I then quickly extrapolate this down so that I don't have to manually enter each one. I am *sure* there is a $R!C type combo I can put into E15 and then just use the drag the little right hand bottom cell handle down isn't there? In other words, the data from the second (horizontal) sheet below to be coped to the related cells in Sheet 1. I deally I want a formula so that if something in Sheet 2 (Expenditure) does change, Sheet 1 is autotragically updated.

 

[FormR]

Hi, if I understand correctly, try this in E15 copied down.

=INDEX(Sheet2!$C$6:$Q$6,ROWS(E$15:E15))

 

[vbthedog]

Bingo! Genius thank you (I have never used the Index command before so had no idea on that one)

Cheers!

David