Extract unique records from data set with duplicates

[dwhite30518]

I have attached a copy of the worksheet I am working with. I would like to create VBA code that would go line by line and if the Repair Order (Column C) is not the same as the record on the row above, then copy and paste on a different sheet.

Ideas??????

[AB33]

Please Login or Register  to view this content.

[dwhite30518]

This is perfect...Thanks!!!!