I work with a program that outputs excel format information. The attached file show the information highlighted that I wish to keep. All the rows that contain code that ends in "HBS", I need to keep. The remainder need to be deleted. Usually, I just manually go through and delete the rows that I do not need, but I was wondering if there is a way to delete all the rows that do not contain cell information that ends in "HBS".
Thanks
Bookmarks