Assign data lines to one worksheet and synchronize data back to the main sheet in Excel

Occasional Visitor

Need Help!

I have several sheets in one excel file, I would like to do the following in excel:

1) Once manager assign a "TC" person (e.g. "peter") in the "GENERAL" sheet,










the whole line will be automatically copied into that TC person's sheet (Sheet "Peter"), I'm currently using "filter" function, but all the functions/colors are not followed to Sheet "Peter", I don't know how to solve;









2) And,  TC (Peter) will need to infill all the data in the line in his sheet, then I would like the data to be synchronized to the "GENERAL" sheet.


P.S. Data Source:

data source.png

Anyone can help me on the above?

Thanks in advance

0 Replies