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
<tbody>
</tbody>
<tbody>
</tbody>
So what I would want to show up on the master tab would be something like this:
<tbody>
</tbody>
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
Project: | Example 1 |
Action | Need By Date |
Finish | 12/01/14 |
Action 5 | 11/22/14 |
Action 4 | 11/19/14 |
Action 3 | 11/16/14 |
Action 2 | 11/12/14 |
Action 1 | 11/06/14 |
<tbody>
</tbody>
Project: | Example 2 |
Action | Need By Date |
Finish | 12/28/14 |
Action 5 | 12/21/14 |
Action 4 | 12/12/14 |
Action 3 | 12/1/14 |
Action 2 | 11/19/14 |
Action 1 | 11/14 |
<tbody>
</tbody>
So what I would want to show up on the master tab would be something like this:
Project: | Action | Need By Date |
Example 1 | Action 3 | 11/16/14 |
Example 1 | Action 4 | 11/19/14 |
Example 2 | Action 1 | 11/14 |
Example 2 | Action 2 | 11/19/14 |
<tbody>
</tbody>
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