Hi Brad,

Visit Chip Pearson's site:

http://www.cpearson.com/excel/duplic...gingDuplicates


---
Regards,
Norman



"Brad K." wrote in message
...
On a monthly basis I have a sheet that is filled with lab data (up to 2000
rows and 15 columns). I need to identify samples that come from repeat
sources (i.e. Row 1 "ID"). When identified, I want to copy all of the
data
for each of the repeat ID's to a new sheet for further analysis.
Anyone have some good ideas for an efficient method to accomplish this?
Thanks in advance for any assistance provided.
Brad