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

  • example.zip
    5.8 KB · Views: 99

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a row to a table (again) 6
Auto Fill Equations in VBA 5
Find Text and Insert Row Above 9
How to get Row # in formula? 7
vba code overwrites formulae? 1
Array formula 4
Formula Array Macro 5
Sum range auto update 3

Top