delete row if column D plus from lower to top >100

[hktom]

Dear all,

Please help
Column A with 1,2,.......
Column D with numbers
Then plus from lower D number ,if >100 Delete row

For example
For Column A , Number 1 form the Low Column D plus to top , that is D14+D13+D12+D11 =80
If plus D10= 101 , then row D10,D9,D8,D7,D6,D5,D4,D3,D2
But Attached file code don’t work, pls help
After code sheet 1 should become sheet 2

Thanks for your great help
Tom

[Mumps1]

Place a header name in cell A1 so that it is not blank. This is necessary for the macro to filter data properly. Then try this macro:

Please Login or Register  to view this content.

[hktom]

Thanks the vba code work perferct!!! ....Many thanks to Mumps1

[Mumps1]

You are very welcome.