I am creating a ss that has six cells with dependent validation (each is dependent on all the previous cells). I would like to have the dependent cells clear when a new selection is made further up the line. So far I've gotten the second cell to clear when I select a new value in the first cell using:
Please Login or Register  to view this content.
(Which I am shamelessly copying from Contextures.com)
but I'm having trouble figuring out how to expand this so it clears the 3rd cell and on down the line, and I'm totally baffled as to how to have the 3rd cell etc. clear if I select a new value in the 2nd but leave the 1st the same
Any help would be much appreciate.