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" wrote in message
...
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" wrote in message
...
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