I have a macro-enable workbook with one tab containing task data; This tab is named CutoverHxH. Columns I & K contain data validation which pulls from a list on the tab named Arrays. In column I, the user can select a single value (a person's name). Column J is reserved for a function buttton (per line) if needed. Column K uses the same Data Validation lookup, but I would like to be able to select and display multiple values (2 or more names).
I have attached the workbook for reference. Any suggestion on how I might go about this?
You mean to say you want to be able thru datavalidation in Col K to be able to select more than 1 item ??
If the answer is yes then it is not possible thru data validation it could be possible thru a combobox set to exctended but this would require additional code to align the combobox on each line each time you select it.