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

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

Tom:
Thanks.

http://www.rondebruin.nl/copy5.htm looks like it will perform the task.

WC

"Tom Ogilvy" wrote:

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