I am enclosing an excel file to help show what i am trying to do.
I have a template that i want some users (co-workers) to fill out. Right now i have "two" templates one for JR and one for SR.
Someone suggested that i try and make a single template where the user selects JR or SR from drop down list in cell B3.
Based on this selection different values would be populated in the sheet.........i have tried to highlight the values that would change in light yellow based on selection in cell B3.
Now, i am not even sure this is worth trying to do depending on how complicated it is. I am not ever sure where to begin to try this.
Ideally, as i said , i am looking to replace my two templates with a single one. User/coworker would make a selection in cell B3 and then the corresponding items would populate in other parts of the sheet based on the B3 value.