Excel macro required to campare

Closed
Sreekanth - Feb 7, 2010 at 02:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 10:53 AM
Hello,
I have 5 excel sheets in which i need to extract all unique employee IDs in to a new sheet.Means only column "A" should be copied from al workbooks to a new workbook.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 10:53 AM
well if you want to do manually, then
you can copy all cols A to this new sheet and then you can use Data Filter Advance Filter option to remove dups

Of course same can be done with macro, if you record your action once and re-use it when ever you want
0