Forum Discussion
ChrisAvak
Feb 28, 2024Copper Contributor
Simple problem but tricky- Groupings
Hi, I have a simple setup in MS project, where i have 3 items (item A, B, C) and i am performing activities 1 and 2 on these items. Activity 1 and 2 are date fields, where i will put the date when t...
John-project
Feb 28, 2024Silver Contributor
ChrisAvak,
You won't be able to get that format output table directly in Project but it could be ceated in Excel with an export from Project with a macro.
You could do something in Project using multiple Text and Number fields, the Text fields representing the date and the Number fields representing the activity count but that would limit out at 20 days since there are only 20 extra Number fields.
If I wanted this, I would use VBA.
John
You won't be able to get that format output table directly in Project but it could be ceated in Excel with an export from Project with a macro.
You could do something in Project using multiple Text and Number fields, the Text fields representing the date and the Number fields representing the activity count but that would limit out at 20 days since there are only 20 extra Number fields.
If I wanted this, I would use VBA.
John