Hi everyone.
I have a col that contains many other text such as:
A1 - abc
A2 - abc
A3 -abc
A4 - asdkalk
A5 -asdlakjd
A6 -asdkaj
A7 -anything
.
.
A200 -andmore
A number of row that i don't know before
Here, how to use VBA or macro to delete these rows which it doesn't contain "abc", and rows behind must be up.
Thank you for your help.
Bookmarks