Home

gather data from one sheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-401081%22%20slang%3D%22en-US%22%3Egather%20data%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401081%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20file%20to%20make%20it%20easier%20to%20explain%20and%20hopefully%20to%20find%20a%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20file%20there%20is%20a%20tab%20individual%20performance%20and%20working%20hours.%20I%20would%20like%20to%20gather%20from%20the%20tab%20working%20hour%20in%20the%20tab%20individual%20performance%20the%20amount%20of%20hours%20worked%20in%20that%20week%20per%20person.%20how%20can%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401081%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%3CLINGO-SUB%20id%3D%22lingo-sub-401172%22%20slang%3D%22en-US%22%3ERe%3A%20gather%20data%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53148%22%20target%3D%22_blank%22%3E%40Man%20Fai%20Chan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20cant%20seems%20to%20fix%20it%20with%20this.%20Password%20is%201234%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20have%20another%20look%20in%20the%20file%2F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401171%22%20slang%3D%22en-US%22%3ERe%3A%20gather%20data%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401171%22%20slang%3D%22en-US%22%3E%3CP%3EI%20find%20that%20your%20file%20is%20protected%2C%20so%20I%20cannot%20open%20your%20file.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20function%20%22INDIRECT%22%20is%20helpful%20to%20you.%20Let's%20have%20a%20look%20at%20the%20sample%20file%20I%20prepared.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401170%22%20slang%3D%22en-US%22%3ERe%3A%20gather%20data%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401170%22%20slang%3D%22en-US%22%3E%3CP%3EI%20find%20that%20your%20file%20is%20protected%2C%20so%20I%20cannot%20open%20your%20file.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20function%20%22INDIRECT%22%20is%20helpful%20to%20you.%20Let's%20have%20a%20look%20at%20the%20sample%20file%20I%20prepared.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ramon Haagen
Occasional Contributor

Hello,

 

I attached a file to make it easier to explain and hopefully to find a solution.

 

In the file there is a tab individual performance and working hours. I would like to gather from the tab working hour in the tab individual performance the amount of hours worked in that week per person. how can I do this?

3 Replies

I find that your file is protected, so I cannot open your file. 

 

I think the function "INDIRECT" is helpful to you. Let's have a look at the sample file I prepared. 

I find that your file is protected, so I cannot open your file. 

 

I think the function "INDIRECT" is helpful to you. Let's have a look at the sample file I prepared. 

@Man Fai Chan 

 

Hi, I cant seems to fix it with this. Password is 1234

 

Could you have another look in the file/