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