Excel macro required to campare

Closed
Sreekanth - Feb 7, 2010 at 02:49 AM
rizvisa1 Posts 4479 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.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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