MS excel 2010
I am trying to setup a spread sheet that will have the following:
If New Hire is selected from H9 I want B 15 to display DOB: (MM/DD/YYYY) (DOB is entered in B16)
And E15 to display SSN (data is entered in E16) See attached
What I am trying to have this do. is if
Termination is selected you do not see B15/B16 or E15/E16
Or
When change is Selected
B15 says “Current Role” (this will be a drop down H27 – H35)
E16 will say “New Role” (this will use the same drop down as above)
new-employee.xlsx
If New Hire is selected from H9 I want B 15 to display DOB: (MM/DD/YYYY) (DOB is entered in B16)
And E15 to display SSN (data is entered in E16) See attached
What I am trying to have this do. is if
Termination is selected you do not see B15/B16 or E15/E16
Or
When change is Selected
B15 says “Current Role” (this will be a drop down H27 – H35)
E16 will say “New Role” (this will use the same drop down as above)
new-employee.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rob,
you are making good scores these days :-)
questions are answered by you on the fly
you are making good scores these days :-)
questions are answered by you on the fly
Changing jobs and have handed over a lot of things to successor so have more time to spend on EE, rather than just break time.
Great!
New job starts next Monday so probably won't see much from me for a while after that.
ASKER