seggregating email addresses
 

I have few email addresses of my friends in the range A1:F25 in
"Sheet1". I have added few blank worksheets with domain names
("Hotmail", "Gmail", "Yahoo", "Aol" etc). I have 10 worksheets with
different domain names. I want to seperate these email addresses in
"Sheet1" by their domain names and put it in the respective worksheets.


For instance if A1 contains , this email address should
be transferred in the sheet "Hotmail" in cell A1, the next email with
@hotmail should go in A2.

seggregating email addresses
 

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


" wrote:

I have few email addresses of my friends in the range A1:F25 in
"Sheet1". I have added few blank worksheets with domain names
("Hotmail", "Gmail", "Yahoo", "Aol" etc). I have 10 worksheets with
different domain names. I want to seperate these email addresses in
"Sheet1" by their domain names and put it in the respective worksheets.


For instance if A1 contains , this email address should
be transferred in the sheet "Hotmail" in cell A1, the next email with
@hotmail should go in A2.