Does anyone know if it is possible to have a checklist which if the answer is "yes" to one of the options it brings up a sub checklist underneath? Ive got the basic checklist set up using validation lists but wondering if there is a way to take it one step further and show a sub section.
Many thanks.
Replies (3)
Please login or register to join the discussion.
Should be possible
but would require coding of Worksheet_Change in VBA to test the answer and unhide relevant cells
It's easily done
Morning MissAccounting
This is something I use alot and it's easily done with clever construction of the validation tables.
If you could send me your template, with all confidential data removed, but showing your examples, I will send you back a working copy. Please make sure you include your parent/child relationship for all the variables.
My email is: elliott @ recenseo co uk
Kind Regards
Elliott
Here is a link
Hi,
Here is a link from Contextures which explains how to create a dynamic list:
http://blog.contextures.com/archives/2011/02/09/dynamic-excel-drop-down-list/
Hope this helps,
Myles
www.bespokeexceltraining.co.uk