Using Checkboxes to control other sets of checkboxes

Column A is a set of one type of rule conditions 16 rows $A$2:$A$17
Column D is another $D$2:$D$14
And so on.

My objective is to have a "Select all" checkbox that checks only the appropriate groups of cells, and un-checks the others for specific configurations.
I also have a checkbox that I need to turn invisible when another cell ="", and reappear with it isn't.

Lastly, I have a column with several cells with 3 radials. I need each cell to produce numbers independently.
If one equals a cell reference they all equal that cell reference.
Say $L$2:$L$13

Example attached. I tried to format for clarity

Hello Entregan,

Cold you please attach a sample workbook (not a picture or pasted copy).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Hello Entregan,

Your sample Workbook contains formulae extending beyond the range/s in you sample, returning #Ref Errors. I would therefore not be able to assist with your issue. It is also not clear to me exactly what your requirement/s is/are. You have a lot of Check Boxes and Option Buttons, and I cannot figure out how you want them to interact.

Maybe someone else on this Forum might be able to assist you further. Sorry about that.

Regards.