Need formular to follow to newly inserted line and to update forlumas below new line automatically

[maho01ae]

Hi

I need to be able to insert a line in any given line in the range and the above formulas have to be copied to the new line automatically and at the same time update the formulas in the lines below the new line.

The reason for this is that I have a formula that show the number of the visible lines when you filter for certain categories using the following formula - =SUBTOTAL(2;D$1:D2)*1

However as it is now when a line is inserted there will only be blank cells in that line and the formula below will be incorrect.

I would prefer a VBA solution but I’m also interested in a formula too if at all possible.

Im using Excel 2007
Thanks Martin

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-...low-new-line-will-update-too.html#post3438071

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).