G
Guest
I have a spreadsheet with various invoice numbers in column A:
For example:
FC110107-002
PB110107-001
LV010707-001
I need a VBA macro that will delete delete an entire row if the LEFT 2
characters of a cell in column A have either: FC, PB, or GR
The default range of my data is usually rows 2 - 2000
I cannot seem to find other snippets of code that work for my needs, so any
help would be appreciated.
For example:
FC110107-002
PB110107-001
LV010707-001
I need a VBA macro that will delete delete an entire row if the LEFT 2
characters of a cell in column A have either: FC, PB, or GR
The default range of my data is usually rows 2 - 2000
I cannot seem to find other snippets of code that work for my needs, so any
help would be appreciated.