|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
09-16-2024, 08:10 AM
|
||||
|
||||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Want to get the cell value on the bases of dropdown select. Want to copy the data from cell | Puneet Singh | Excel Programming | 0 | 02-08-2022 11:04 AM |
 How to paste the value of a selected cell to another sheet?
|
Learner7 | Excel Programming | 3 | 06-30-2019 10:35 PM |
|
Using Cell Values in Active Sheet to Populate Path to External Reference Link
|
wowcrofty | Excel | 4 | 12-19-2016 12:29 PM |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 11 
Office 2021
Threaded Mode