greeting all!

ok, I feel like a total noob here but this is driving me up a wall. I have peaked around here and was not able to find something that will help...so here I am asking. (if you know of a post that will solve my question, please link me to it!)

I have a worksheet that contains some 8 columns of data. row 8 is the unique identifier. in the event there is a dupe record, the org as well as any other dupe(s) should then be moved to purgatory until someone can review them :-)

I am pretty sure I can do this with 2 loops, but was wondering if there might be another quicker way? I don't suspect I will ever have more than 400 records, but that's just a guess.