In my office, everyday i receive an excel sheet. It contains lot of columns.
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