Format so once cell is marked "Complete" it drops out of the page

[vmanna16]

I've made a spreadsheet documenting goals/tasks along with their due dates and progress. My boss would like me to format the spreasheet so that whenever a task is marked as "Complete" - the entire row will drop from view (either to the next tab or bottom of the same tab) and only "In Progress" items remain in that original area. I've used the Data Validation function to preset those cells with either "In Progress" or "Complete".

I have little to no experience with macros and honestly have to idea where to begin. Can anyone help?

 

[erik.van.geit]

Hi, WELCOME to MrExcel!

You can sort the data to get "completed" at the bottom.
Would that be an option? First you can try out manually.
I assume you can find out how to sort.

It's so quick that adding code wouldn't be much faster, but it can be done of course: for instance each time that a cell within the "progress" column would change, the data would be sorted.

kind regards,
Erik

kind regards,
Erik

 

[vmanna16]

Thanks for the reply Erik. I've been playing with the sort function as well and even applying custom settings, I've still a bit lost on how I could get lines to move down/off the page. Could you provide a little more insight there?

Thanks,

Vince

 

[erik.van.geit]

Sure,
Perhaps we can work with a little example, let's say a few rows with some "progress" and "completed".
before and after sorting

Then tell what exactly you want to do.
Would hiding the rows be an option?

best regards,
Erik