Can someone please tell me how to permanently delete the filtered rows from
the same sheet so that the row numbers at left are re-aligned as
1,2,3,4,5,6,7,8,9 etc instead of 1,5,9 etc. Specially when you are dealing
with large data of 179,000 lines. I have already tried to copy and paste to
new sheet but it does not work in large data.
Thanks