Forum Discussion

JasonGuan2022's avatar
JasonGuan2022
Copper Contributor
Feb 20, 2022

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

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

No RepliesBe the first to reply

Resources