I have a list of part numbers in table1. Some begin with "STNY". I want a macro to delete all items that begin with "STNY"
Example:
Table1
Column1
STNY123
ATNY345
STNY456
ATNY567
STNY678
ATNY6789
Results after macro
Table1
Column1
ATNY345
ATNY567
ATNY6789
Thanks!
Nicole
Example:
Table1
Column1
STNY123
ATNY345
STNY456
ATNY567
STNY678
ATNY6789
Results after macro
Table1
Column1
ATNY345
ATNY567
ATNY6789
Thanks!
Nicole