What I would like to do is have all my list values stored in one cell
as Item1,Item2,Item3 etc

I would like to the reference this single cell and then the list Items
would appear ina drop down as:

Item1
Item2
Item3

The reason I am trying to do this is that I have many cells to
populate - the following thread goes into a bit more detail:
http://www.mrexcel.com/forum/showthr...36#post2388936