Hey guys!
I'm trying to create a summary of action tab in a workbook to track several projects. On each tab there are actions, and a complete by date for each action. I want to pull in to a master summary tab any actions that are upcoming in the next 7 business days.
What needs to happen in the code I'm looking for is as follows:
I need this to run on 10+ tabs and pull all actions into the master tab. Each tab essentially looks like this
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Example 1[/TD]
[/TR]
[TR]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Finish[/TD]
[TD]12/01/14[/TD]
[/TR]
[TR]
[TD]Action 5[/TD]
[TD]11/22/14[/TD]
[/TR]
[TR]
[TD]Action 4[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Action 3[/TD]
[TD]11/16/14[/TD]
[/TR]
[TR]
[TD]Action 2[/TD]
[TD]11/12/14[/TD]
[/TR]
[TR]
[TD]Action 1[/TD]
[TD]11/06/14[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Example 2[/TD]
[/TR]
[TR]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Finish[/TD]
[TD]12/28/14[/TD]
[/TR]
[TR]
[TD]Action 5[/TD]
[TD]12/21/14[/TD]
[/TR]
[TR]
[TD]Action 4[/TD]
[TD]12/12/14[/TD]
[/TR]
[TR]
[TD]Action 3[/TD]
[TD]12/1/14[/TD]
[/TR]
[TR]
[TD]Action 2[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Action 1[/TD]
[TD]11/14[/TD]
[/TR]
</tbody>[/TABLE]
So what I would want to show up on the master tab would be something like this:
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Example 1[/TD]
[TD]Action 3[/TD]
[TD]11/16/14[/TD]
[/TR]
[TR]
[TD]Example 1[/TD]
[TD]Action 4[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Example 2[/TD]
[TD]Action 1[/TD]
[TD]11/14[/TD]
[/TR]
[TR]
[TD]Example 2[/TD]
[TD]Action 2[/TD]
[TD]11/19/14[/TD]
[/TR]
</tbody>[/TABLE]
It's a big one... any ideas? I'm borderline VBA illiterate but I know other coding languages. Please explain in steps what your code does and I can follow it easily
I'm trying to create a summary of action tab in a workbook to track several projects. On each tab there are actions, and a complete by date for each action. I want to pull in to a master summary tab any actions that are upcoming in the next 7 business days.
What needs to happen in the code I'm looking for is as follows:
- Find any date in the next 7 business days
- Copy that date to a cell in a master tab in the same file
- In a cell to the left of the date found above, copy the action that is associated with that date
- In a cell to the left of the action copy the tab name (this is the project name- also store in a cell on the tab
I need this to run on 10+ tabs and pull all actions into the master tab. Each tab essentially looks like this
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Example 1[/TD]
[/TR]
[TR]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Finish[/TD]
[TD]12/01/14[/TD]
[/TR]
[TR]
[TD]Action 5[/TD]
[TD]11/22/14[/TD]
[/TR]
[TR]
[TD]Action 4[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Action 3[/TD]
[TD]11/16/14[/TD]
[/TR]
[TR]
[TD]Action 2[/TD]
[TD]11/12/14[/TD]
[/TR]
[TR]
[TD]Action 1[/TD]
[TD]11/06/14[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Example 2[/TD]
[/TR]
[TR]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Finish[/TD]
[TD]12/28/14[/TD]
[/TR]
[TR]
[TD]Action 5[/TD]
[TD]12/21/14[/TD]
[/TR]
[TR]
[TD]Action 4[/TD]
[TD]12/12/14[/TD]
[/TR]
[TR]
[TD]Action 3[/TD]
[TD]12/1/14[/TD]
[/TR]
[TR]
[TD]Action 2[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Action 1[/TD]
[TD]11/14[/TD]
[/TR]
</tbody>[/TABLE]
So what I would want to show up on the master tab would be something like this:
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Project:[/TD]
[TD]Action[/TD]
[TD]Need By Date[/TD]
[/TR]
[TR]
[TD]Example 1[/TD]
[TD]Action 3[/TD]
[TD]11/16/14[/TD]
[/TR]
[TR]
[TD]Example 1[/TD]
[TD]Action 4[/TD]
[TD]11/19/14[/TD]
[/TR]
[TR]
[TD]Example 2[/TD]
[TD]Action 1[/TD]
[TD]11/14[/TD]
[/TR]
[TR]
[TD]Example 2[/TD]
[TD]Action 2[/TD]
[TD]11/19/14[/TD]
[/TR]
</tbody>[/TABLE]
It's a big one... any ideas? I'm borderline VBA illiterate but I know other coding languages. Please explain in steps what your code does and I can follow it easily
