vba, macro, shift down after autofilter

[mawar5530]

Hi Friends,

I am new to vba, really need help to find solution.
After autofilter the selction of "Poitem" example, i want to change G coloumn number beloging to "Poitem" to "zero" value
i dont find any way to offset, because the range keep on changing acording to report, so the offset not working for me.

 

[MARK858]

The formulas increment the row number fine for me for both the code lines with formulas for column H with Sheet1 as the activesheet..

 

[mawar5530]

The formulas increment the row number fine for me for both the code lines with formulas for column H with Sheet1 as the activesheet..

ok do u save the file back ? or i just apply it