Need selected dropdown value in a cell of one sheet to populate same cell on other sheets
Same old worksheet covering six aircraft.
Column C of each sheet uses a dropdown list to say the row is for either: -200 ONLY, -300 ONLY, or BOTH.
Currently, each sheet has its own data validation drop down list source range (same cell range, just re-entered on each sheet).
My question is, is there a way to make a selection in the cell on one sheet populate the corresponding cell in every other sheet?
So, let's say that in cell C9 of Sheet 3, someone selects "-200 ONLY" from the dropdown. It should set cell C9 of Sheet 1, 2, 4, 5, and 6 to -"-200 ONLY" also.
Is this possible?
|