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 sheet -
"Sheet 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 sheet, 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 sheet, 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.