PDA

View Full Version : Sleeper: How to find out



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

Benzadeus
12-16-2008, 05:01 PM
I didn't understand very well...

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

Kenneth Hobs
12-16-2008, 05:05 PM
It unclear what you want.