Populating table

%3CLINGO-SUB%20id%3D%22lingo-sub-1677025%22%20slang%3D%22en-US%22%3EPopulating%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1677025%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20creat%20a%20sheet%20with%20a%20productivity%20summary%20table%20based%20on%20dates.%20I%20have%20one%20sheet%20like%20a%20shift%20report%20that%20has%20date%20In%20one%20column%20and%20comments%20in%20a%20second%20column.%20I%20have%20another%20productivity%20sheet%20that%20can%20be%20filtered%20by%20week.%20In%20this%20I%20have%20a%20table%20that%20shows%20data%20from%20that%20week.%20I%20want%20to%20pull%20the%20comments%20into%20it%20from%20the%20original%20sheet%20against%20other%20productivity%20data.%3CBR%20%2F%3EHow%20do%20I%20do%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1677025%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-1677096%22%20slang%3D%22de-DE%22%3ESubject%3A%20Populating%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1677096%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F796883%22%20target%3D%22_blank%22%3E%40Beth_is%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20something%20like%20this%20can%20help%20you%20in%20the%20right%20direction.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20not%20please%20just%20ignore%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am trying to creat a sheet with a productivity summary table based on dates. I have one sheet like a shift report that has date In one column and comments in a second column. I have another productivity sheet that can be filtered by week. In this I have a table that shows data from that week. I want to pull the comments into it from the original sheet against other productivity data.
How do I do this?
1 Reply

@Beth_is 

 

Maybe something like this can help you in the right direction. If not please just ignore it.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.