The title might not be the best to describe what I need, but I can't
think of the words to describe what I need. Here goes the long
version.

I have a spreadsheet that has ~20,000 rows in it. In one column, (B),
I have a list of email addresses. What I need to do, somehow, is scan
each of the lines and pull out all of the possible domain names that
are there. I don't want a count of each time each domain name is
listed, but if there is a domain name listed, it needs to be added to
another "master list".

So, for example, I may have data like this.

Row # | EMail Address | Misc. Other Data
1 | | other stuff
2 | | other info
3 | | miscellaneous data
4 |
etc...etc...

Then (perhaps on a sheet called "DOMAINS" (which I've already made and
labelled)) I'd like to have this master list show up on another sheet.
For the example above, I'd like my list to show:

Row #1 | Domain Name
1 | test.com
2 | yahoo.com
3 | some.domain.com
(notice how test.com was already there, so we dont' need to add it
again).

I am VERY comfortable with VB and VBA scripting, so anything and
everything you could give me would be greatly appreciated.

Thank you!
Any Questions about possible ambiguities due to my writing, please post
back!


--
mateo107
------------------------------------------------------------------------
mateo107's Profile: http://www.excelforum.com/member.php...o&userid=22299
View this thread: http://www.excelforum.com/showthread...hreadid=532115