How to find duplicates across multiple sheets?

**david08** · 01-16-2013, 01:52 AM

Hello to all,
This is david. I feel happy to join with you people.
I have 10 workbooks, (1 workbook contains 10sheets)
Now i have to find the duplicates In column A.,
First i have to compare all 10 sheets in one workbook.,Likewise Other Workbooks
After that i have to compare 1 Workbook to another workbook.,Likewise all 10 workbook
It takes more time to find unique data. can give me some suggestions.

Thank you& Regards
david
rxdrugonlinestore.com

**arlu1201** · 01-16-2013, 02:29 AM

How is it that you have posted the same question as http://www.excelforum.com/excel-form...le-sheet.html? But with a different user ID?

**david08** · 01-16-2013, 02:55 AM

Hai to all,

This is david. First of all thanks for helping me. Actually what i mean to say is i want program for finding duplicates across multiple sheets in any one of the language.

Thank you & Regards
david

**arlu1201** · 01-16-2013, 02:56 AM

This does not answer my question in post 2, david.

**david08** · 01-16-2013, 03:04 AM

I Want extension of one of the viewer question. And this is my unique id david08 and [email protected]. If i did any mistake please suggest me sir, I continued that question. Those are my id details.

Thank you & Regards
david

**arlu1201** · 01-16-2013, 06:04 AM

You could have framed your question differently. You have copy pasted the exact contents. If your question is the same, you can wait to see what solutions come through.