Hello,
I have a list of about 300,000 company names with 1,000 of them being usable. The usable company names have content in column C. I essentially need to delete any row that does not have content in column C, but I need to keep five rows above and five rows below any company with criteria in column C. Sometimes the criteria in column C is two rows apart, sometimes it is 50,000 rows apart. What is the VBA script for this? Below is a screen shot...
I have a list of about 300,000 company names with 1,000 of them being usable. The usable company names have content in column C. I essentially need to delete any row that does not have content in column C, but I need to keep five rows above and five rows below any company with criteria in column C. Sometimes the criteria in column C is two rows apart, sometimes it is 50,000 rows apart. What is the VBA script for this? Below is a screen shot...
![77r39.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.freeimagehosting.net%2Fnewuploads%2F77r39.jpg&hash=6b3870a4e8a53f566fd69df9532251dd)