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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Project Coordinator[/TD]
[TD]Task #1[/TD]
[TD]Status[/TD]
[TD]Task #2[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Project#1[/TD]
[TD]Mark[/TD]
[TD]3/14/2017[/TD]
[TD]Expected[/TD]
[TD]4/20/2017[/TD]
[TD]Expected[/TD]
[/TR]
[TR]
[TD]Project#2[/TD]
[TD]James[/TD]
[TD]3/25/2017[/TD]
[TD]Done[/TD]
[TD]3/26/2017[/TD]
[TD]Expected[/TD]
[/TR]
[TR]
[TD]Project#3[/TD]
[TD]Jimmy[/TD]
[TD]3/24/2017[/TD]
[TD]Expected[/TD]
[TD]4/14/2017[/TD]
[TD]Expected[/TD]
[/TR]
</tbody>[/TABLE]
I want to return the following on a new sheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Project Coordinator[/TD]
[TD]Task Name[/TD]
[TD]Task Due Date[/TD]
[TD]Task Status[/TD]
[TD]Days until Due Date[/TD]
[/TR]
[TR]
[TD]Project #1[/TD]
[TD]Mark[/TD]
[TD]Task #1[/TD]
[TD]3/14/2017[/TD]
[TD]Expected[/TD]
[TD]-8[/TD]
[/TR]
[TR]
[TD]Project #2[/TD]
[TD]James[/TD]
[TD]Task #2[/TD]
[TD]3/26/2017[/TD]
[TD]Expected[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Project #3[/TD]
[TD]Jimmy[/TD]
[TD]Task #1[/TD]
[TD]3/24/2017[/TD]
[TD]Expected[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Project#3[/TD]
[TD]Jimmy[/TD]
[TD]Task #2[/TD]
[TD]3/28/2017[/TD]
[TD]Expected[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Project Coordinator[/TD]
[TD]Task #1[/TD]
[TD]Status[/TD]
[TD]Task #2[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Project#1[/TD]
[TD]Mark[/TD]
[TD]3/14/2017[/TD]
[TD]Expected[/TD]
[TD]4/20/2017[/TD]
[TD]Expected[/TD]
[/TR]
[TR]
[TD]Project#2[/TD]
[TD]James[/TD]
[TD]3/25/2017[/TD]
[TD]Done[/TD]
[TD]3/26/2017[/TD]
[TD]Expected[/TD]
[/TR]
[TR]
[TD]Project#3[/TD]
[TD]Jimmy[/TD]
[TD]3/24/2017[/TD]
[TD]Expected[/TD]
[TD]4/14/2017[/TD]
[TD]Expected[/TD]
[/TR]
</tbody>[/TABLE]
I want to return the following on a new sheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Project Coordinator[/TD]
[TD]Task Name[/TD]
[TD]Task Due Date[/TD]
[TD]Task Status[/TD]
[TD]Days until Due Date[/TD]
[/TR]
[TR]
[TD]Project #1[/TD]
[TD]Mark[/TD]
[TD]Task #1[/TD]
[TD]3/14/2017[/TD]
[TD]Expected[/TD]
[TD]-8[/TD]
[/TR]
[TR]
[TD]Project #2[/TD]
[TD]James[/TD]
[TD]Task #2[/TD]
[TD]3/26/2017[/TD]
[TD]Expected[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Project #3[/TD]
[TD]Jimmy[/TD]
[TD]Task #1[/TD]
[TD]3/24/2017[/TD]
[TD]Expected[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Project#3[/TD]
[TD]Jimmy[/TD]
[TD]Task #2[/TD]
[TD]3/28/2017[/TD]
[TD]Expected[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]
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.