Wow! Works great, but I have 1 question though... if I had data(name in this case) that did not have more than one duplicate name in column A for example. How hard is it to update this macro so that it writes that row too? This seems to only write out the ones on sheet two that have duplicates and doesn't touch the ones that don't. If it's too hard, then I can work with this as is and I REALLY appreciate the help. Thanks !