View Single Post
 
Old 09-16-2024, 08:10 AM
SnakeDoctor's Avatar
SnakeDoctor SnakeDoctor is offline Windows 11 Office 2021
Advanced Beginner
 
Join Date: Jul 2023
Location: Ft. Worth, TX
Posts: 38
SnakeDoctor is on a distinguished road
Red face 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?
Reply With Quote