Hello,
I need to create a projects assignment status table that is updated automatically from projects assignment table.
I have a projects table with jobs at the table rows and months at the columns.
I assign people to the jobs in the projects months forward. ('Projects Assignment' sheet at the attached file).
I need to see the assignment status for a choosen month ('Projects Status' sheet at the attached file).
I'll choose the month and the table will show the assignments planned to the projects at this month.
it needs to be by formulas and not by macro.
thanks,
Amit
I need to create a projects assignment status table that is updated automatically from projects assignment table.
I have a projects table with jobs at the table rows and months at the columns.
I assign people to the jobs in the projects months forward. ('Projects Assignment' sheet at the attached file).
I need to see the assignment status for a choosen month ('Projects Status' sheet at the attached file).
I'll choose the month and the table will show the assignments planned to the projects at this month.
it needs to be by formulas and not by macro.
thanks,
Amit