Highlight Duplicates, Macro?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello all,

I need something to help me find duplicates within a big workbook over
different Sheets.

At the moment im using a few columns of =IF(COUNT IF... But with about
15 Sheets, and about 2000 lines of each, its slowing it down
considerably.

I have a macro that works, but basically it takes the latest *** -
"*** 15" (for example), and then looks at one at a time.
Also its a bit messy and can add lines and all sorts sometimes.

What Id like a macro to do is to take a ***, perhaps set by a pop up
box.
Then to set a column range, like D:D.. which WILL be the same on every
Sheeet, if that helps.
To find duplicates, and put a 1, or an X in another column.

So basically i want to select the Current Month ***, and then have
the macro sweep the rest of the workbook in the same column for
duplicates, and higlight them.

Thanks if you can help, i didnt really want to use a macro, they dont
agree with me - but the formulas are slowing it all down considerably.

Again, thanks if you can help.
.

Quantcast