LeeHitchen
New Member
- Joined
- Mar 20, 2002
- Messages
- 26
Hi All
I have a number of worksheets containg 5 digit numbers located in column A. Some of these numbers are duplicated ie appear on more than one sheet. Is there a quick way to 'merge' these numbers from all worksheets ending up with a distinct list? At the moment I'm cutting and pasting the numbers from each sheet until I end up with one long list and then filtering to end up with a distinct list. However, as you can imagine, with a large number of worksheets this is more than a little tedious.
Thanks for your help.
Lee
I have a number of worksheets containg 5 digit numbers located in column A. Some of these numbers are duplicated ie appear on more than one sheet. Is there a quick way to 'merge' these numbers from all worksheets ending up with a distinct list? At the moment I'm cutting and pasting the numbers from each sheet until I end up with one long list and then filtering to end up with a distinct list. However, as you can imagine, with a large number of worksheets this is more than a little tedious.
Thanks for your help.
Lee