Hi all,

I am having trouble with removing some data before inserting it into a
pivot table. In column g of my excel database, i have shift -trip
numbers in the following format XXXXXXX-X. Where all X's are numbers.
My issue is that I need to find all shift-trip numbers that end in -1
and copy and paste them to a new page, these are the entries I need
for further analysis. Any ideas on how to recognize the end "-1"? I
am not having luck with anything I've seen online so far, though I am
very new to vb.

Thanks in advance,
Kyle