Situation is:
Overall rows 7 - 42 will be hidden, when I click on check box 1, I want it to unhide rows 7, 13, 19, 24, 30, 36, and 41 - with the remaining rows within the entire (7-42) range still hidden (unless they were previously unhidden with the check box click). Then when I click on check box 2, it will unhide rows 8-10 - leaving the remaining rows hidden (unless they were previously unhidden with the check box click). Then when I click on check box 3 it will unhide rows 11-12 - leaving the remaining rows hidden (unless they were previously unhidden with the check box click).
Originally the subsequent check boxes weren't working because the 1st check box was overriding. I started to do a 'nesting' effect, but the check boxes wouldn't stay locked in their original spots, it would hide / show the rows for the most part but toward the end it was moving check boxes all over the spreadsheet. I tried using format control to lock but it was unsuccessful.
Any thoughts?
Bookmarks