Hi there,
This morning i ask for macro that works great. But now i have a little issue to solve.
In a excel sheet in the column D, i got some value write in some cell. The value is ''ACTIVE''.
I try to make a macro, to everytime the macro find ''ACTIVE'' in D column, the macro delete that line and remove the blanck cell with push up data. (delete total line OR A to D), and continu to the next till the end(never the same amount of row).
Thanks a lot master of EXCEL
Michellin
This morning i ask for macro that works great. But now i have a little issue to solve.
In a excel sheet in the column D, i got some value write in some cell. The value is ''ACTIVE''.
I try to make a macro, to everytime the macro find ''ACTIVE'' in D column, the macro delete that line and remove the blanck cell with push up data. (delete total line OR A to D), and continu to the next till the end(never the same amount of row).
Thanks a lot master of EXCEL
Michellin