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

%3CLINGO-SUB%20id%3D%22lingo-sub-3189588%22%20slang%3D%22en-US%22%3EAssign%20data%20lines%20to%20one%20worksheet%20and%20synchronize%20data%20back%20to%20the%20main%20sheet%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3189588%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20Help!%3C%2FP%3E%3CP%3EI%20have%20several%20sheets%20in%20one%20excel%20file%2C%20I%20would%20like%20to%20do%20the%20following%20in%20excel%3A%3C%2FP%3E%3CP%3E1)%20Once%20manager%20assign%20a%20%22TC%22%20person%20(e.g.%20%22peter%22)%20in%20the%20%22GENERAL%22%20sheet%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22GENERAL.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349758i60A790ADD0EB1A62%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GENERAL.png%22%20alt%3D%22GENERAL.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20whole%20line%20will%20be%20automatically%20copied%20into%20that%20TC%20person's%20sheet%20(Sheet%20%22Peter%22)%2C%20I'm%20currently%20using%20%22filter%22%20function%2C%20but%20all%20the%20functions%2Fcolors%20are%20not%20followed%20to%20Sheet%20%22Peter%22%2C%20I%20don't%20know%20how%20to%20solve%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Peter.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349759iB881F58779998EF0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Peter.png%22%20alt%3D%22Peter.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20And%2C%26nbsp%3B%20TC%20(Peter)%20will%20need%20to%20infill%20all%20the%20data%20in%20the%20line%20in%20his%20sheet%2C%20then%20I%20would%20like%20the%20data%20to%20be%20synchronized%20to%20the%20%22GENERAL%22%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20Data%20Source%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22data%20source.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349760i1640176611478DA6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22data%20source.png%22%20alt%3D%22data%20source.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnyone%20can%20help%20me%20on%20the%20above%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3189588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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,

GENERAL.png

 

 

 

 

 

 

 

 

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;

Peter.png

 

 

 

 

 

 

 

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