I have a worksheet I'm trying to streamline.
I want to amalgamate 5 columns into one by having an incell dropdown menu which allows me to add 1 or more values to the same cell (ie a,b,c,d,e).
After reading some of Debrah Dalgleish's posts I managed to do this with this little gem
http://www.contextures.com/DataValMultiSelect.zip under the "samecell" sheet. Its perfect!
However, I would also like to use the code from the "Linebreak" sheet (a dropdown menu which stacks 1 or more values in a neighbouring cell), in a different column within my stremlined worksheet. Also in the same cell as opposed to the one next to it!
Its a Visual Basic code thing, something way outside my realm, so tread gently please.
Thankyou in advance
Sean
Microsoft Office