Copy data to multiple sheets

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transferring data from multiple sheets in workbook to one sheet 5
Update multiple sheets 1
Copy specific data form sheets into master sheet 6
Scroll Lock for selected multiple sheets 2
Copy data to different sheets 6
copy an exact formula without changing cell reference 1
Multiple column search and Copy 7
Merge Multiple workbook sheets into one workbook 0

Top