VBA for Duplicates Across 13 Columns

[mrsbrannon]

Hello everyone,

I am trying to get a VBA code that will highlight duplicates found across 13 columns of data, possibly 100+ rows of data. So I'm looking for duplicated rows across those 13 columns. See below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]DOB[/TD]
[TD]Address[/TD]
[TD]Phone[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[TD]Etc[/TD]
[/TR]
[TR]
[TD]John Brown[/TD]
[TD]1/1/1992[/TD]
[TD]123 main[/TD]
[TD]1234[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John Brown[/TD]
[TD]1/1/1992[/TD]
[TD]123 main[/TD]
[TD]1234[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Please note that my data for checking starts in column C, not A. So it's Columns C thru O.

Thank you!

 

[Fluff]

How is the data added?

 

[mrsbrannon]

Copied and pasted from multiple worksheets. So once the data is pasted, find the dups.

 

[Fluff]

That might make it harder
How are you doing the copy/paste? By hand or by macro?

 

[mrsbrannon]

By hand It's not a HUGE deal. If we have to run the Macro, so be it. It would just be a nice feature.

 

[mrsbrannon]

I tried conditional formatting but with copying/pasting new data weekly, the range always changed.

 

[Fluff]

By hand It's not a HUGE deal. If we have to run the Macro, so be it. It would just be a nice feature.

The best option, would probably be to start a new thread explaining what you are doing re the copy/paste from other sheets.
Then, if that is sorted, you can simply call this macro at the end. That way the whole process will be automated.

 

[mrsbrannon]

Okay. I'm always up for automation. The data is coming from outside sources though, via a new worksheet daily, so I'm not sure if that could be automated, but if so that would be great.