excel 2003

[Wiley C]

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 Ogilvy]

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" <WileyC@discussions.microsoft.com> wrote in message
news:998199BC-30C0-476F-B6CA-CB6395A44A08@microsoft.com...
> 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

[Wiley C]

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" <WileyC@discussions.microsoft.com> wrote in message
> news:998199BC-30C0-476F-B6CA-CB6395A44A08@microsoft.com...
> > 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
>
>
>