auto update formula ref if new row inserted

K

ktchegi

Joined
Apr 14, 2007
Messages
2
Reaction score
0
In my "example" I have references in AG2:AH11 which take data from B19:U19. Is it possible to automatically update these formulae if a row is inserted eg above my row 20? The formula in AG2 should then change from =OFFSET(B20,-1,0) to =OFFSET(B21,-1,0) and so on. TIA
 

Attachments

Back
Top