Excel help

Excel help

Didn't find your answer?

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.

avatar
By ACDWebb
28th Sep 2011 17:07

Should be possible

but would require coding of Worksheet_Change in VBA to test the answer and unhide relevant cells

Thanks (0)
avatar
By ElliottRoss
29th Sep 2011 08:00

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

www.recenseo.co.uk

Thanks (0)
By clarityconsultancy
03rd Oct 2011 17:07

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

 

Thanks (0)