Having a row automatically move once it has been resolved

%3CLINGO-SUB%20id%3D%22lingo-sub-1429026%22%20slang%3D%22en-US%22%3EHaving%20a%20row%20automatically%20move%20once%20it%20has%20been%20resolved%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429026%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20how%20to%20fully%20explain%20what%20I%20need%20but%20I%20am%20working%20on%20a%20sheet%20where%20we%20are%20resolving%20some%20lost%20items.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20that%20I%20can%20move%20the%20resolved%20ones%20to%20the%20top%20of%20the%20sheet%20and%20leave%20all%20the%20pending%20ones%20open%20on%20the%20bottom%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20the%20image%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1429026%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-1429032%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20a%20row%20automatically%20move%20once%20it%20has%20been%20resolved%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429032%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684459%22%20target%3D%22_blank%22%3E%40mvargas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20sort%20the%20data%20by%20the%20column%20where%20you%20mark%20resolved%20items.%26nbsp%3B%20You%20can%20turn%20on%20AutoFilter%20or%20you%20can%20turn%20the%20whole%20data%20into%20an%20Excel%20Table.%20Then%20you%20get%20arrows%20in%20the%20header%20column%20that%20you%20can%20click%20on%20to%20sort%20the%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429095%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20a%20row%20automatically%20move%20once%20it%20has%20been%20resolved%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684459%22%20target%3D%22_blank%22%3E%40mvargas%3C%2FA%3E%26nbsp%3BTo%20expand%20on%20previous%20reply%20by%20a%20fellow%2C%20you%20could%20set%20a%20Custom%20Sort%20on%20the%20whole%20dataset%20with%3A%3C%2FP%3E%3CP%3E1st%20level%20-%20Sort%20by%20%22Resolved%20Day%22%20-%20Sort%20on%3A%20Cell%20Value%20-%20Order%3A%20Newest%20to%20Oldest%3C%2FP%3E%3CP%3EThen%20click%20on%20%22Add%20level%22%3A%3C%2FP%3E%3CP%3E2nd%20level%20-%20Sort%20by%20%22Opened%20Day%22%20-%20Sort%20on%3A%20Cell%20Value%20-%20Order%3A%20Newest%20to%20Oldest%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CustomSort.png%22%20style%3D%22width%3A%20591px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195541iF653E67B1C399255%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22CustomSort.png%22%20alt%3D%22CustomSort.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, 

 

I am not sure how to fully explain what I need but I am working on a sheet where we are resolving some lost items. 

Is there any way that I can move the resolved ones to the top of the sheet and leave all the pending ones open on the bottom?

 

Hopefully the image can help.

 

Thank you!

2 Replies
Highlighted

Hello @mvargas 

 

You could sort the data by the column where you mark resolved items.  You can turn on AutoFilter or you can turn the whole data into an Excel Table. Then you get arrows in the header column that you can click on to sort the data.

 

 

 

Highlighted

@mvargas To expand on previous reply by a fellow, you could set a Custom Sort on the whole dataset with:

1st level - Sort by "Resolved Day" - Sort on: Cell Value - Order: Newest to Oldest

Then click on "Add level":

2nd level - Sort by "Opened Day" - Sort on: Cell Value - Order: Newest to Oldest

 

 

CustomSort.png