Hi All,
I have been trying to wrap my head around how to write this, but I need help.
Basically, I want to scan a large set of data (mostly dates) and return upcoming data + their respective tasks. The tricky thing is that I don't want to return tasks that are already "done". Below is a sample of my data:
<tbody>
</tbody>
I want to return the following on a new sheet:
<tbody>
</tbody>
For the new list on the new sheet, I need to display any dates past due + any due dates coming up in the next week. Is this possible with VBA? or is there a better way to automatically sort the data and do this?
I appreciate any help, or any direction anyone can provide on this for me.
I have been trying to wrap my head around how to write this, but I need help.
Basically, I want to scan a large set of data (mostly dates) and return upcoming data + their respective tasks. The tricky thing is that I don't want to return tasks that are already "done". Below is a sample of my data:
Project Name | Project Coordinator | Task #1 | Status | Task #2 | Status |
Project#1 | Mark | 3/14/2017 | Expected | 4/20/2017 | Expected |
Project#2 | James | 3/25/2017 | Done | 3/26/2017 | Expected |
Project#3 | Jimmy | 3/24/2017 | Expected | 4/14/2017 | Expected |
<tbody>
</tbody>
I want to return the following on a new sheet:
Project Name | Project Coordinator | Task Name | Task Due Date | Task Status | Days until Due Date |
Project #1 | Mark | Task #1 | 3/14/2017 | Expected | -8 |
Project #2 | James | Task #2 | 3/26/2017 | Expected | 4 |
Project #3 | Jimmy | Task #1 | 3/24/2017 | Expected | 2 |
Project#3 | Jimmy | Task #2 | 3/28/2017 | Expected | 6 |
<tbody>
</tbody>
For the new list on the new sheet, I need to display any dates past due + any due dates coming up in the next week. Is this possible with VBA? or is there a better way to automatically sort the data and do this?
I appreciate any help, or any direction anyone can provide on this for me.