Using Excel to generate a customized, printable form based on certain selected cells?

Hi guys,

Searching for this is making my head spin, and I have tried a few approaches without getting the exact result I'm looking to achieve.

I'd prefer to do this without macros if possible, as that's really above my paygrade.

Ideally, this is what I'm envisioning: a bunch of checkboxes or drop-downs that the user fills out according to variable parameters (on a list of A-Z, I might check B,C,D,G,H,T,Z). Based on whatever "options" are selected, a printable list is populated that consists of information pulled from a different sheet, and may contain one or many lines (rows).

Here is my theory:

User checks option 'A' on sheet 'OPTIONS' by placing a check mark in A2.
Sheet 'VALUES' contains a 5-row list of tasks that pertain to 'A', located in VALUES!A2:A5.
Sheet 'RESULT' checks value in OPTIONS!A2, sees "check" (TRUE) value, returns VALUES!A2:A5.


At the moment, since I can't figure out how to get the checkbox working correctly, I've been using a modified ISBLANK formula to detect "NOTISBLANK". However, anytime I try to reference multiple cells or a range, I can't get more than one to display:

Please Login or Register  to view this content.

I'd like this printable list to automatically hide blanks, so I have it formatted as a table with blanks hidden. That is great, but I'm having to manually refresh it each time one of the "options" change.


Is this the best way to be doing this? Any ideas on how I can improve upon this without going crazy with macros / VB?



Thanks, all.

Anybody have any ideas?

Thanks for the quick reply.


Attached is a workbook that (sort of) resembles what I'm looking for. Open to suggestions about how to make it more user-friendly / functional.

Thank you!
testing-custom-form-builder.xlsx