I am trying to set up a drop down list that allows me to select multiple items and then list them in a single cell separated by a comma. I have tried using samples that were listed in the discussion board here but I am obviously doing something wrong.
I have limited excel experience and I do not understand VBG but I was able to set up drop down list that allow one selection. I just need to get them change to multiple sections.
I have two columns that will require multiple sections from a drop down list. First list will be located in Column-G second list located in Column-I. I have the data list located on a different worksheet within the same workbook.
Data List for Column G
Printer
Phone
Scanner
Laptop
Monitor
Docking Station
Chair
Desk
File
the list is labeled SFEquipment
Data List for Column-I
Cabinets
Chairs
Desk
File Cabinet
Phone
Printer
Scanner
Shelves
the list is labeled NonSFequipment
When a new employee is added to the worksheet all the cells in Column G and Column must have these drop down lists.
Thank you for you help.
Karen
I have limited excel experience and I do not understand VBG but I was able to set up drop down list that allow one selection. I just need to get them change to multiple sections.
I have two columns that will require multiple sections from a drop down list. First list will be located in Column-G second list located in Column-I. I have the data list located on a different worksheet within the same workbook.
Data List for Column G
Printer
Phone
Scanner
Laptop
Monitor
Docking Station
Chair
Desk
File
the list is labeled SFEquipment
Data List for Column-I
Cabinets
Chairs
Desk
File Cabinet
Phone
Printer
Scanner
Shelves
the list is labeled NonSFequipment
When a new employee is added to the worksheet all the cells in Column G and Column must have these drop down lists.
Thank you for you help.
Karen