After I've gone through and entered a value or made a selection from the dropdowns, if I later change the value in a cell, how can I have every other cell that correlates to that cell update to the new value?
your worksheet is really huge...
It's hard to understand for me, what it does. A smaller example would be very nice.
Could you make a new sample worksheet with only little data and drop-down and explain which cells should update and which can be selected/modified.