Hello,
I'm a newbie with Excel, and would appreciate some help. I've created an excel spreadsheet for our organization to help with catering.
My first worksheet is the startup and there are a number of Checkbox control objects which the user can choose from options of food. For supper, for example, they can choose between 1-6 choices using checkboxes. The worksheet is quite long because it includes Breakfast, Morning Tea, Lunch, Afternoon Tea, and Supper.
After they've made their choices, I want another spreadsheet to compile just their choices and turn it into a list. So for supper, I would like the spreadsheet to just name the items they've chosen (which ranges between 1 and 6 items). Then we can have a quick glance at it without going through the entire original worksheet.
I have no clue how to do this. My choices (which are all control checkboxes) are in cells C4:C10. They are linked to cells D4:D10. So when ever there is a "TRUE" in cells D4:D10, I want the corresponding item in C4:C10 to be listed vertically. I'm not sure if this is possible because C4:C10 has no text? It only has checkboxes with the corresponding label.
The other problem is that sometimes there will be only 1 TRUE selected, but other times, people choose more than 1 so the resulting list will also be varying lengths, though there is a set maximum.
Would really appreciate any help!
I'm a newbie with Excel, and would appreciate some help. I've created an excel spreadsheet for our organization to help with catering.
My first worksheet is the startup and there are a number of Checkbox control objects which the user can choose from options of food. For supper, for example, they can choose between 1-6 choices using checkboxes. The worksheet is quite long because it includes Breakfast, Morning Tea, Lunch, Afternoon Tea, and Supper.
After they've made their choices, I want another spreadsheet to compile just their choices and turn it into a list. So for supper, I would like the spreadsheet to just name the items they've chosen (which ranges between 1 and 6 items). Then we can have a quick glance at it without going through the entire original worksheet.
I have no clue how to do this. My choices (which are all control checkboxes) are in cells C4:C10. They are linked to cells D4:D10. So when ever there is a "TRUE" in cells D4:D10, I want the corresponding item in C4:C10 to be listed vertically. I'm not sure if this is possible because C4:C10 has no text? It only has checkboxes with the corresponding label.
The other problem is that sometimes there will be only 1 TRUE selected, but other times, people choose more than 1 so the resulting list will also be varying lengths, though there is a set maximum.
Would really appreciate any help!