I'm looking to have a list appear when a cell is clicked. The user should be able to click on multiple list items if needed. The list items would come from another tab which can be updated.. soo to restate this:
In Tab1(/sheet 1) When the user clicks on a cell in the column (all cells in the column will have this functionality) I would like a list of checkbox items to appear as options (more than 1 can be clicked). I would like the list to be pulled from the items put in tab/sheet2.
Note: if more items are added/updated in the list in tab 2, I would like the checkbox list in tab 1 to update automatically/dynamically
I'm using Excel 2013
Thanks!!
In Tab1(/sheet 1) When the user clicks on a cell in the column (all cells in the column will have this functionality) I would like a list of checkbox items to appear as options (more than 1 can be clicked). I would like the list to be pulled from the items put in tab/sheet2.
Note: if more items are added/updated in the list in tab 2, I would like the checkbox list in tab 1 to update automatically/dynamically
I'm using Excel 2013
Thanks!!