Hi

I have a workbook with up to 30 sheets, one of which is the master sheet.
Upon entering one of 2 options in column "C" on the master sheet I want it to
then copy cells within that line to specific other sheets in the workbook

For instance if "Fred" is the selected option I would want cell A1,B1,G1,T1
(maybe others, I have to work that bit out but certainly not the whole row)
to be copied to sheets - Bob, Geoff and Frank but not the others. Is this
possible? This will be a continuallly growing workbook so the copied data
will need to find the next empty line each time rather than copy over
existing data. Hope this makes sense and someone can help!?

Possible yes.

See Ron de Bruin's site for copy/paste/merge examples.

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

The "maybe others, I have to work that bit out" would mean adjusting the code
you get from Ron's site.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 03:40:00 -0800, HighlandRoss
wrote:

Hi

I have a workbook with up to 30 sheets, one of which is the master sheet.
Upon entering one of 2 options in column "C" on the master sheet I want it to
then copy cells within that line to specific other sheets in the workbook

For instance if "Fred" is the selected option I would want cell A1,B1,G1,T1
(maybe others, I have to work that bit out but certainly not the whole row)
to be copied to sheets - Bob, Geoff and Frank but not the others. Is this
possible? This will be a continuallly growing workbook so the copied data
will need to find the next empty line each time rather than copy over
existing data. Hope this makes sense and someone can help!?

Thanks Gord, I'll check it out.

"Gord Dibben" wrote:

Possible yes.

See Ron de Bruin's site for copy/paste/merge examples.

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

The "maybe others, I have to work that bit out" would mean adjusting the code
you get from Ron's site.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 03:40:00 -0800, HighlandRoss
wrote:

Hi

I have a workbook with up to 30 sheets, one of which is the master sheet.
Upon entering one of 2 options in column "C" on the master sheet I want it to
then copy cells within that line to specific other sheets in the workbook

For instance if "Fred" is the selected option I would want cell A1,B1,G1,T1
(maybe others, I have to work that bit out but certainly not the whole row)
to be copied to sheets - Bob, Geoff and Frank but not the others. Is this
possible? This will be a continuallly growing workbook so the copied data
will need to find the next empty line each time rather than copy over
existing data. Hope this makes sense and someone can help!?