Home

Dynamic List

%3CLINGO-SUB%20id%3D%22lingo-sub-528894%22%20slang%3D%22en-US%22%3EDynamic%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528894%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20two%20lists%20for%20work%20and%20I%20would%20like%20to%20make%20it%20easier%20to%20consolidate%20it.%20What%20I%20want%20to%20do%20is%20take%20two%20lists%20and%20make%20a%20third%20that%20combines%20them%20as%20one.%20However%2C%20I%20want%20it%20to%20be%20based%20on%20criteria%20of%20%22In%20Progress%22%20housed%20in%20another%20cell%20once%20it%20no%20longer%20says%20that%20I%20would%20like%20the%20third%20list%20to%20remove%20that%20and%20then%20shift%20the%20list%20up.%20Once%20all%20items%20have%20been%20completed%20it%20then%20has%20nothing%20on%20the%20third%20sheet.%20Is%20this%20possible%3F%20What%20would%20I%20use%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-528894%22%20slang%3D%22en-US%22%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-529157%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-529157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F333206%22%20target%3D%22_blank%22%3E%40Master-Yoshi%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20combine%20all%20In%20Progress%20from%20first%20lists%20by%20Power%20Query%20and%20land%20result%20into%20the%20third%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Master-Yoshi
Occasional Visitor

I am working on two lists for work and I would like to make it easier to consolidate it. What I want to do is take two lists and make a third that combines them as one. However, I want it to be based on criteria of "In Progress" housed in another cell once it no longer says that I would like the third list to remove that and then shift the list up. Once all items have been completed it then has nothing on the third sheet. Is this possible? What would I use?

1 Reply

@Master-Yoshi , you may combine all In Progress from first lists by Power Query and land result into the third sheet.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 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