Hello,
I need to create a projects human resource status table that is updated automatically from an 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 human resource status table that is updated automatically from an 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
