Ron de Bruin has code samples to do various copies for this type of
situation. You should be able to adapt one to your needs.

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

--
Regards,
Tom Ogilvy


"Wiley C" wrote in message
...
Excel 2003, part of Office Professional 2003
Windows XP Pro SP2

Spreadsheet currently has text columns & data [ US $ ] columns.
Columns A, B, C have information about the contact
Data is in columns D, E, F
Column H notes the group to which the the contact belongs
I would like:

the contacts of each group to be sent to a separate file / document /
spreadsheet, so that a mailing list can be created, by group.

Thanks for your help.

WC