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
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.
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:
- Excel macro required to campare
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
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
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
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