| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows containing Vendor Total A,B,C etc
Hi
I am looking for a macro that will delete entire rows from a report containing the phrase 'Vendor Total' followed by Company name. Here is an example of the raw data:- Company Apple Vendor Total Company Apple Vendor Total Company Banana Vendor Total Company Banana Company Orange Company Apple Vendor Total Comapany Pear Once the macro has run and deleted out the entire lines containg Vendor Total, the following data should remain:- Company Apple Company Orange Company Apple There is a header in row 1 that should remain. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
| Creating a Vendor ID from Vendor Name... | Excel Worksheet Functions | |||
| Delete Rows that Contain the Text "Total" and vice versa | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
| Search "Total" in all worksheets and delete rows containing "Total" | Excel Programming | |||
Threaded Mode
