Auto Update Cell References

[chmof13]

Good afternoon,

Could someone please help me with a problem I am having? I am trying to reference a cell in Sheet1 by using ='Sheet2'!A2 for example and carry it down to ='Sheet2'!A30, but when I insert a row between that range and type in information it doesn't auto update. Further explanation: Sheet 2 A2 I have "10" and I go all the way to Sheet 2 A21 which will be "2000"; well let's say that I insert a row on Sheet 2 A3 that says "15", I need that to auto update my references. I expanded my range to allow changes like this to be made but it is not working the way I thought it would. Can someone please help me?

 

[Giordano Bruno]

Have you tried the OFFSET function. Suppose for example, in cell A2 of Sheet1 you write the formula =OFFSET(Sheet2!A$2,ROW()-2,0) and copy it down this will give you the values in each consecutive row even if you insert or delete rows on Sheet2. Does that help?

 

[chmof13]

It sort of did! I managed to modify your formula slightly to make it work. Thank you for your help!!