review for duplicates and fill the same

[schusterstories]

Hello smart people,

I have a large spreadsheet i'm using for people's names/addresses/phone numbers etc

I have to add more constantly when a new download becomes available. However, on my initial sheet I fill the row (example, they don't want to be contacted is red, left a message yellow)
I want to have a macro so it will review the whole sheet and if there is a duplicate row that it will copy the fill also.

Any help is appreciated!
Michelle

 

[James006]

Hello,

A couple of extremely quick fixes ...

1. Sort your Database

or

2. Insert a Pivot Table

Hope this will help