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

vmanna16

New Member
Joined
Feb 4, 2014
Messages
2
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?
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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

New Member
Joined
Feb 4, 2014
Messages
2
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

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top