Dynamic lists

%3CLINGO-SUB%20id%3D%22lingo-sub-3241413%22%20slang%3D%22en-US%22%3EDynamic%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241413%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EI%20have%20created%20a%20worksheet%20that%20uses%20a%20list%20to%20show%20me%20who%20my%20employees%20are%20and%20who%20my%20formen%20are.%20I%20have%20a%20drop-down%20with%20two%20options%3A%20Employee%20%26amp%3B%20Forman.%20When%20Employee%20is%20selected%20it%20shows%20me%20the%20list%20of%20employees%20and%20vice%20versa.%20However%2C%20if%20I%20enter%20information%20in%20the%20cells%20next%20to%20the%20names%20of%20my%20employees%20displayed%20and%20then%20switch%20to%20my%20list%20for%20formen%2C%20the%20information%20in%20the%20cells%20next%20to%20the%20employees'%20names%20still%20remains%20in%20the%20cells%20entered.%3C%2FP%3E%3CP%20class%3D%22%22%3EIs%20there%20a%20way%20when%20switching%20between%20the%20two%20to%20have%20the%20information%20entered%20stay%2Fmove%20with%20the%20list%20when%20switching%3F%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20hope%20that%20makes%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3241413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3245050%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245050%22%20slang%3D%22en-US%22%3EIn%20order%20for%20the%20information%20data%20to%20be%20dynamic%2C%20it%20must%20be%20dependent%20on%20the%20cells%20that%20change%20with%20your%20selection.%20Are%20you%20using%20an%20if%20function%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

I hope that makes sense.

1 Reply
In order for the information data to be dynamic, it must be dependent on the cells that change with your selection. Are you using an if function?