Sorry, that didn't sound too clear. Row A (Sheet 1) has a list of serial numbers (alphanumeric). I'm looking to be able to loop through that row and copy a list of the numbers as in the example below but can't figre out how to do it. Any help appreciated.
Row A
a2314
a2314
b345
b346
a2314
b346
c478
So what will be copied in a new row is:
a2314
b345
b346
c478
Last edited by wonderdunder; 06-30-2011 at 10:16 AM.
It sounds like you want to get the unique values from COLUMN A. Use the advanced filter, and check unique items only.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Now why didn't I think of that! Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks