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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER