(Solved) – Remove Filtered Rows and Delete Also Save Into Macro


In my office, everyday i receive an excel sheet. It contains lot of columns.

For Eg.

I have 8 columns of and more than 15000 rows below the columns.

Name, Division, Type, Packing, Exp Date, Stock Position, Value, Division Code

Now, My problem is,

I need to delete the rows which are comes under the specific Division code.

For example if i have a division code of “1234”, then the entire rows that depends on 1234 of division code should be deleted.

Sometimes i need to delete more than 10 division codes.

Let me know how to do this. Also let me know if there are any possible to do without writing
vba code.

Leave a Reply

Your email address will not be published. Required fields are marked *