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:
Anyone can help me on the above?
Thanks in advance