I have a doubt .,could anyone answer my query
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 anyone suggest good idea