Sleeper: How to find out

[rahullambe]

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

[Benzadeus]

I didn't understand very well...

What should appear at D33, D34, D35 and D36 after running the macro?

[Kenneth Hobs]

It unclear what you want.