-
Sleeper: How to find out
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
-
I didn't understand very well...
What should appear at D33, D34, D35 and D36 after running the macro?
-
It unclear what you want.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules