Hi,
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:
Certified passive
Indoor air quality
Low running costs
Low allergy & healthy building
Low environmental impact
Natural building
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!
Bookmarks