I didn't see that you always have the unique items were always in column
A, so the first part of the macro looks for the title 'Unique' in the
first sheet.

To eliminate duplicates, it would be easiest to loop through the
populated columns.

In article ,
"CompleteNewb" wrote:

Thanks for offering that VBA. From the looks of it, this would actually
address the issue with multiple identical column header entries (like if a
value from Sheet1 happens to be in A5, A10, A122, etc.). However, when I
try it, it just goes to the msgbox saying no unique values found, which I
know can't be the case. I made sure the sheet titles are correct; do you
know why the check returns the msgbox?

Thanks again, your help is very much appreciated.