Copying and Pasting:write a macro

I have a master spreadsheet "Master",
with a list (35 lines) of 15 products. e.g. Siemens, Motorola,Nokia (Some
products have more than one line).

I have have another workbook with 15 worksheets (one worksheet for each
product).

I need to write a macro which will copy the lines from the "Master" into
each of the worksheets, so that for example- the Motorola Lines are copied to
the worksheet caleed "Motorola"

Thanks

See Ron de Bruin's site. He has sample code for a situation like this:

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

--
Regards,
Tom Ogilvy


"teresa" <teresa@discussions.microsoft.com> wrote in message
news:7E6D2E11-8D36-4710-8FF3-99692ECF25D4@microsoft.com...
> I have a master spreadsheet "Master",
> with a list (35 lines) of 15 products. e.g. Siemens, Motorola,Nokia (Some
> products have more than one line).
>
> I have have another workbook with 15 worksheets (one worksheet for each
> product).
>
> I need to write a macro which will copy the lines from the "Master" into
> each of the worksheets, so that for example- the Motorola Lines are copied
to
> the worksheet caleed "Motorola"
>
> Thanks
>

Thanks Tom

"Tom Ogilvy" wrote:

> See Ron de Bruin's site. He has sample code for a situation like this:
>
> http://www.rondebruin.nl/tips.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "teresa" <teresa@discussions.microsoft.com> wrote in message
> news:7E6D2E11-8D36-4710-8FF3-99692ECF25D4@microsoft.com...
> > I have a master spreadsheet "Master",
> > with a list (35 lines) of 15 products. e.g. Siemens, Motorola,Nokia (Some
> > products have more than one line).
> >
> > I have have another workbook with 15 worksheets (one worksheet for each
> > product).
> >
> > I need to write a macro which will copy the lines from the "Master" into
> > each of the worksheets, so that for example- the Motorola Lines are copied
> to
> > the worksheet caleed "Motorola"
> >
> > Thanks
> >
>
>
>