rahullambe
12-16-2008, 10:51 AM
Hi dear friends,
I have 1 sheet where there are some projects and their sub projects mentioned in ROW D & ROW E contains project Code ROW F contains sub-projects code ROW F, G & H contains Active part time and non active status of the employees.
below this chart there is a employee code which contains the project code+ sub project code +Active/ Part-Timer/ Non-Active status of the employee.
Attached is the sheet for your reference.
Now I want is:-
I have more than 100 codes, when I run any formula or Macro the I should get project name in next column of the code, sub project namein next column of project name, & status of the employee on the project.
Please help me.
Thanks.
Rahul:help
I have 1 sheet where there are some projects and their sub projects mentioned in ROW D & ROW E contains project Code ROW F contains sub-projects code ROW F, G & H contains Active part time and non active status of the employees.
below this chart there is a employee code which contains the project code+ sub project code +Active/ Part-Timer/ Non-Active status of the employee.
Attached is the sheet for your reference.
Now I want is:-
I have more than 100 codes, when I run any formula or Macro the I should get project name in next column of the code, sub project namein next column of project name, & status of the employee on the project.
Please help me.
Thanks.
Rahul:help