update formula when row inserted

I am attaching 2 worksheets. In example 2, thanks to excellent advice from this forum, I am able to update the results in the last 3 columns if I insert groups of 3 cols. Same applies if I remove cols.
My question is with "example" I have results on the right side of the worksheet. If I insert a row, is there some way of automatically updating the results to reflect the new row data? This would have to happen each time I insert a new row.

Originally Posted by ktchegi

I am attaching 2 worksheets. In example 2, thanks to excellent advice from this forum, I am able to update the results in the last 3 columns if I insert groups of 3 cols. Same applies if I remove cols.
My question is with "example" I have results on the right side of the worksheet. If I insert a row, is there some way of automatically updating the results to reflect the new row data? This would have to happen each time I insert a new row.

Hi,

to insert a row,

Please Login or Register  to view this content.

set that as a macro, and use macro Options to set a Shortcut Key, the new row will be inserted before the Total row, and details from A and the three Total columns should copy down.

hth
---

Once again, thanks. However, I would like to add some info. In my "example" I have data in T19 (56) which reflects in AG11 as same. I now insert a row and feed in data at T20 (lets say 10) which I want to show in AG11 as "10". The area in my worksheet AD2 to AH12 is used to update info only for each row as it is inserted. Have a good day

OK, it seems that the OFFSET function works. If I set AG2 as "=OFFSET(B20,-1,0)" and AH2 as "=OFFSET(C20,-1,0)" then AG3 as "=OFFSET(D20,-1,0)" etc I get the desired result when I insert rows.
Thanks for an "excel"lent forum