1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Create checklist that inserts list or keeps boxes empty depending on checked/unchecked

Hi all! I am trying to create an excel sheet for my job.

I need to turn tracking sheet with normal check boxes into a “questionnaire” type of spreadsheet where it asks ‘Does this person have X?’ , if the answer is ‘Yes’, it needs to populate a list of items that’s needed (there will be multiple questions like this).

The reason I need this is because the spreadsheet I have now is clogged up with all of the items in the list, whether the person needs it or not. I would like to make it cleaner, in a way that I don’t have to completely re-do the spreadsheet every time I have to make a tracker sheet.

Anyone able to teach me how to use formulas and formatting? Tried playing around with them and they don’t do what I need to do.

submitted by /u/Puzzleheaded-Dot6895
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article