Hey everyone, this is my issue. I have 2+ separate drop down lists in 2+ separate cells that have the exact same lists (Clean, Dirty). I want to be able to select either clean or dirty in one cell and have all the other cell automatically update to that value and vice versa.
The scenario for this usage follows. One material is listed 2+ times in my worksheet and I would like the status of this material to be consistent throughout when any updates are made anywhere in this worksheet.
Bookmarks