I have created a worksheet that uses a list to show me who my employees are and who my formen are. I have a drop-down with two options: Employee & Forman. When Employee is selected it shows me the list of employees and vice versa. However, if I enter information in the cells next to the names of my employees displayed and then switch to my list for formen, the information in the cells next to the employees' names still remains in the cells entered.
Is there a way when switching between the two to have the information entered stay/move with the list when switching?