Hi, I have a requirement where I have an excel file in these I have multiple sheets.
Now my requirement is for particular sheet suppose sheet1.
In this sheet I have multiple columns like Date | Type | Destination | Arrival time and so on
so these Rows is in 11th Rows.
I have to select these complete row Then click on Wrap Data(Optional if there is an shortcut we can use) Then I have to click on Data Tab the Filter. Once click on filter I have to filter the Type Column then select specific item from this lets say Order, PurchaseDate once done with the filter I have to delete the data from the rows 12th till end.
Any way to do this please suggest.
This is just an sample but in real my data is huge So I have to filter and delete all rows data from 12th row till end