Hello,
First off - I'm no where near an expert with excel and programming so I'm sure there are some better ways to do what I've created on my attached workbook example - I'm open to recommendations if I can figure out how to do it :-)
On my workbook there are three tabs - Data, Selections, and Output. The user would go to the "Selections" tab and check the check boxes for each question that applies. On the "data" tab, the column "C" will change to true when that question is selected on the "Selections" tab. I want to look at all the "True" fields and have the corresponding questions (in column A of the "Data" tab) that are true copied to the "output" sheet under the correct header "Buffer", "High", "Medium", or "Low" (listed in column B of the "data" tab).
(example workbook is attached)
Any help would be greatly appreciated! Like I said, if I've done this completely *** backwards and someone is willing to help me streamline this, I'm all ear.
Thanks again!
Alan
Bookmarks