Seamus2626
asked on
Sub to delete rows after key word
I have a spreadsheet, which has a key word called "SYSTEMICS" (Highlighted Yellow)
I want to be able to delete all rows after that word is found.
I have attached an example, it is always in ColB
Thanks
Seamus
test.xls
I want to be able to delete all rows after that word is found.
I have attached an example, it is always in ColB
Thanks
Seamus
test.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi robhenson, i needed vba code for this as i need it to run as a procedure
Thanks Zwiekhorst
Cheers,
Seamus
Thanks Zwiekhorst
Cheers,
Seamus
A helper column with a count of occurences of the word in cells above will show which to delete.
Assuming column C is available enter in C2
=COUNTIF(B$2:B2,"SYSTEMICS
Copy down for extent of data.
AutoFilter on this column for greater than zero and delete the rows showing in the filter.
Cheers