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?
I have little to no experience with macros and honestly have to idea where to begin. Can anyone help?