I am needing some vba code to delete rows if columns contain blanks (specifically column E) and define the sheet name as "data". I have 20000 records in this table so I need something efficient. Any help would be appreciated.
<tbody>
</tbody>
Supplier | Terminal | Product | Location | Manager | Customer | Price | Rank | Eff.Date | Eff.Time |
Supplier2 | Terminal18 | Product5 | Location1 | Manager1 | Customer1 | Price | 1 | 6/6/18 | 12:00 AM |
Supplier2 | Terminal18 | Product5 | Location1 | Manager1 | Customer1 | Price | 1 | 6/6/18 | 12:00 AM |
Supplier3 | Terminal8 | Product5 | Location6 | Manager2 | Customer2 | Price | 3 | 6/5/18 | 6:00 PM |
Supplier3 | Terminal8 | Product5 | Location6 | Manager2 | Customer2 | Price | 3 | 6/5/18 | 6:00 PM |
Supplier3 | Terminal8 | Product5 | Location6 | Manager2 | Customer2 | Price | 8 | 6/5/18 | 6:00 PM |
Supplier3 | Terminal8 | Product5 | Location6 | Manager2 | Customer2 | Price | 8 | 6/5/18 | 6:00 PM |
Supplier4 | Terminal10 | Product5 | Location6 | Manager2 | Customer2 | Price | 5 | 6/5/18 | 6:00 PM |
Supplier4 | Terminal10 | Product5 | Location6 | Manager2 | Customer2 | Price | 5 | 6/5/18 | 6:00 PM |
Supplier5 | Terminal5 | Product5 | Location5 | Customer2 | |||||
Supplier5 | Terminal5 | Product5 | Location5 | Customer2 | |||||
Supplier5 | Terminal6 | Product1 | Location5 | Customer2 | |||||
Supplier5 | Terminal6 | Product5 | Location5 | Manager2 | Customer2 | Price | 2 | 6/6/18 | 12:01 AM |
Supplier5 | Terminal6 | Product5 | Location5 | Manager2 | Customer2 | Price | 2 | 6/6/18 | 12:01 AM |
Supplier5 | Terminal7 | Product5 | Location11 | Manager2 | Customer2 | Price | 3 | 6/5/18 | 6:00 PM |
Supplier5 | Terminal7 | Product5 | Location11 | Manager2 | Customer2 | Price | 2 | 6/5/18 | 6:00 PM |
Supplier5 | Terminal12 | Product1 | Location10 | Customer2 | |||||
Supplier5 | Terminal12 | Product5 | Location10 | Customer2 | |||||
Supplier5 | Terminal12 | Product5 | Location10 | Customer2 | |||||
Supplier5 | Terminal14 | Product5 | Location11 | Manager3 | Customer2 | Price | 1 | 6/6/18 | 12:01 AM |
Supplier5 | Terminal14 | Product5 | Location11 | Manager3 | Customer2 | Price | 1 | 6/6/18 | 12:01 AM |
Supplier6 | Terminal7 | Product1 | Location11 | Customer2 | |||||
Supplier6 | Terminal7 | Product5 | Location11 | Manager3 | Customer2 | Price | 3 | 6/6/18 | 12:01 AM |
Supplier6 | Terminal7 | Product5 | Location11 | Manager3 | Customer2 | Price | 2 | 6/6/18 | 12:01 AM |
Supplier7 | Terminal16 | Location13 | Location15 | Manager3 | Customer2 | Price | 1 | 6/5/18 | 6:00 PM |
<tbody>
</tbody>