0

I am trying to create an Excel spreadsheet, The user can select as many task scenarios as they want, once they are done I want to automate the responses separating it by task.

For examples there are check boxes with following tasks:

  • Make bed
  • brush teeth
  • mop floor
  • fold laundry

Then once the user selects the tasks they are looking for an out put below will show: (comma's separate cells)

Make Bed
Who's responsible, how do they make the bed, how long should it take the bed

Brush Teeth
Who's responsible, how do they brush their teeth, how long should it take to brush teeth

etc.

I currently have a macro set up that when a user selects check boxes, I put in a formula that states if checked then show "xxxx" and hard coded in each cell for each task) issue is when not all check boxes are checks then there are blank cells and bottom ones could get lost, and does too nice option since the formula states if its not checked its blank.

Another nice to have would be having user selecting task and user group, that way I could show that user groups tasks for that task as opposed to many task items for the overall task that are irrelevant to the user. I hope its clear.

Improve this question
4
  • 2
    Please show the code you already have tried. Stack Overflow is not a free code writing service. Commented Aug 21, 2017 at 14:13
  • I did a simple macros with this formula- I do not have code and I am trying to figure out how to make this be more dynamic. I am assuming VBA would be an option as well as a pivot table but cant seem to get the output I need or want. This is the formula I have: =IF(A4=TRUE, "XXXX", IF(A4=FALSE, " ")) Commented Aug 21, 2017 at 14:17
  • @DebraHeinrich If you have multiple checkboxes, you may want to use a loop to cycle through checkboxes, or have an array with the names of each checkbox and cycle through it. Please see stackoverflow.com/questions/38991201/… as a starting point. Commented Aug 21, 2017 at 15:24
  • thanks! just needed some inspiration! Commented Aug 21, 2017 at 16:10
Related questions
1
Check box to select and deselect all other check boxes in spreadsheet
0
Writing code that applies to multiple check boxes in VBA
1
VBA Excel CheckBox to select all of some specific Checkboxes on Sheet
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.