If someone could come up with or has a macro laying around that would help with the following, I'd be eternally grateful!
If you have a look at the workbook attached you'll see catergory N, 'ProjectImperatives'.
This cell is populated from a multiple choice list on a web form, the user gets to select any or all of the following:
Indoor air quality
Low running costs
Low allergy & healthy building
Low environmental impact
Near passive/low energy
Other (please state)
Whichever they've chosen is returned to me in a single cell. What I then want is a seperate column extracted for each of those choices, just saying 'Yes', if it was selected, or blank if not. So I end up with 8 new columns inserted in place, and what was column O 'Categories' will know be at column U or thereabouts. Hope this makes some sort of sense....
It seems like it should be simple enough, but my head is about to burst from trying to figure it out. Please help!