Compare two Worksheets

[barnard89]

Hi

I am using Excel 2000
I have a workbook which contains multiple worksheets
Each worksheet has only one column ie Column A (SSN ID). This Column is to maintain all the SSNs of the employees.

All the columns A in all worksheets are only for SSN

Normally all SSNs are supposed to be unique.
But sometimes there might be some duplicates which might spread across worksheets
ie a SSN present in Sheet1 might also be present in Sheet2 or Sheet3 and Sheet4

How can I identify these duplicate repeating values spread across the worksheets?

Please advise

thanks

 

[SkipVought]

Hi,

"Each worksheet has only one column ie Column A"

Why have multiple sheets, each with ONE COLUMN of SSN's? What's the purpose for this?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]