jawnmallon
New Member
Hello all,
I will attach 2 spreadsheets to make this as less confusing as I know how.
The old sheet that I used worked great with some help of my friends on here. That one is titled "OM CHECKLIST-2" and essentially what it did was keep track of tasks separated by different departments which were entered in the tabs labled "OPS", "PROD", "KITCHEN", "ARENA", etc.
You were then able to run a report on the "COMP" tab which would show all of the completed tasks and remove them from the tabs where they were input.
Lastly, the first tab labeled "TO DO" would require you to put the current date in and it would generate all tasks that are scheduled to be worked on that day.
I'd like to change it a bit for a new project I am working on to essentially do the same but the objective is to enter some info into the tabs labled "7-30" and "8-6" (week ending dates) and once all of the info is entered, I would like to be able to run that report on the "COMPLETED" tab which would show all completed tasks and remove them from the page where they were input.
Lastly, just as in the first sheet, I'd like to run a report on the "OUTSTANDING" tab that would show me any task whose STATUS is not shown as Complete....so this would show all tasks whose status read "In Progress" or "Not Started".
Hopefully someone out there is much better with VBA than I am because I'm about to jump out of this window!
Thanks in advance,
Jawn
I will attach 2 spreadsheets to make this as less confusing as I know how.
The old sheet that I used worked great with some help of my friends on here. That one is titled "OM CHECKLIST-2" and essentially what it did was keep track of tasks separated by different departments which were entered in the tabs labled "OPS", "PROD", "KITCHEN", "ARENA", etc.
You were then able to run a report on the "COMP" tab which would show all of the completed tasks and remove them from the tabs where they were input.
Lastly, the first tab labeled "TO DO" would require you to put the current date in and it would generate all tasks that are scheduled to be worked on that day.
I'd like to change it a bit for a new project I am working on to essentially do the same but the objective is to enter some info into the tabs labled "7-30" and "8-6" (week ending dates) and once all of the info is entered, I would like to be able to run that report on the "COMPLETED" tab which would show all completed tasks and remove them from the page where they were input.
Lastly, just as in the first sheet, I'd like to run a report on the "OUTSTANDING" tab that would show me any task whose STATUS is not shown as Complete....so this would show all tasks whose status read "In Progress" or "Not Started".
Hopefully someone out there is much better with VBA than I am because I'm about to jump out of this window!
Thanks in advance,
Jawn