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.
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.