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:

Name

DOB

Address

Phone

Etc

Etc

Etc

Etc

Etc

Etc

Etc

Etc

Etc

John Brown

1/1/1992

123 main

1234

John Brown

1/1/1992

123 main

1234

<tbody>
</tbody>

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.