Home

Extract List of Items which are "overdue"

%3CLINGO-SUB%20id%3D%22lingo-sub-802012%22%20slang%3D%22en-US%22%3EExtract%20List%20of%20Items%20which%20are%20%22overdue%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20tab%20which%20contains%20a%20bunch%20of%20products%2C%20and%20tasks%20for%20each.%20I%20wish%20to%20have%20a%20seperate%20tab%20which%20shows%20just%20the%20items%20which%20are%20overdue%2C%20whom%20is%20responsible%2C%20how%20far%20overdue%20and%20any%20comments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20the%20spreadsheet%2C%20with%20an%20example%20of%20%22overdue%20items%22%20tabs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20is%20to%20come%20from%20the%20%22task%20list%20tracker%22%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20any%20assistance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-802012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802048%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20List%20of%20Items%20which%20are%20%22overdue%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20consider%20Power%20Query%20as%20an%20option%20to%20generate%20you%20tables%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
calof1
Contributor

Hi,

 

I have a tab which contains a bunch of products, and tasks for each. I wish to have a seperate tab which shows just the items which are overdue, whom is responsible, how far overdue and any comments.

 

Attached is the spreadsheet, with an example of "overdue items" tabs.

 

The data is to come from the "task list tracker" tab.

 

Thank you kindly for any assistance. 

1 Reply

@calof1 

 

Do you consider Power Query as an option to generate you tables?

Related Conversations