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
Frequent 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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies