H
HighlandRoss
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!?
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!?