stonelaw119
New Member
- Joined
- Aug 28, 2007
- Messages
- 17
Hello!
I am really hoping someone would be able to help me out with this request. I'm working on a project plan with a gantt view. The last thing I need to include are tasks that have not been formally added to our system. I've created a table (OustandingTasks) that calculates the number of Tasks "To-Be-Created" along with the Project name, category, ETD, AHT and Avg Workdays.
Example:
Oustanding Tasks Project Category Delivery Date AHT Workdays
115 WestSide Development 12/31/2017 28.8 22.2
25 SouthSide Requirements 10/31/2017 22.2 15.0
What I am looking to do is for each of the 115 outstanding tasks for the "westside" project have row created in a different sheet/table. The new sheet/row would have Project name, category, ETD, AHT and Avg Workdays in the ROW and include another column called TASKid that labels each row with TBC-1, TBC-2, TBC-3 ...TBC-115. The VBA would then move on to the next project in the list and so the same thing.
I have approximately 10 Projects that can have several hundred outstanding tasks. So I was really hoping that there is a way to do this in VBA.
Anyone able to help me with this?
I am really hoping someone would be able to help me out with this request. I'm working on a project plan with a gantt view. The last thing I need to include are tasks that have not been formally added to our system. I've created a table (OustandingTasks) that calculates the number of Tasks "To-Be-Created" along with the Project name, category, ETD, AHT and Avg Workdays.
Example:
Oustanding Tasks Project Category Delivery Date AHT Workdays
115 WestSide Development 12/31/2017 28.8 22.2
25 SouthSide Requirements 10/31/2017 22.2 15.0
What I am looking to do is for each of the 115 outstanding tasks for the "westside" project have row created in a different sheet/table. The new sheet/row would have Project name, category, ETD, AHT and Avg Workdays in the ROW and include another column called TASKid that labels each row with TBC-1, TBC-2, TBC-3 ...TBC-115. The VBA would then move on to the next project in the list and so the same thing.
I have approximately 10 Projects that can have several hundred outstanding tasks. So I was really hoping that there is a way to do this in VBA.
Anyone able to help me with this?
Last edited:
