Data Validation - Multiple results in the one cell commma separated.

[bradh1983]

Hi all, i am in need of some help please with an old favorite. i have done this in the past but can't find my old worksheet to cheat from.

So, i have 2 worksheets that i am currently working on. First sheet is call Daily Input and the second sheet is called Data. The data sheet has name ranges in it for quick reference purposes.

What i am trying to achieve is on the Daily Input sheet i have a cell where the user is to select which model has been enquired on for the day. They select cell h4 for validation list to drop down choices. I need them to be able to select more than 1 model throughout the day.

a copy of the worksheet is available here to look at if it will make it easier for you. FileSnack | Easy file sharing


Thanks for your help in advance.

 

[bradh1983]

Any thoughts or suggestions are greatly appreciated.