I have 2 cells containing the same picklist values on separate sheets. I want the cells to mirror each other so that whenever I choose a new value in either sheet 1 or sheet 2, the value on the other sheet is updated to match the newly selected value. Is this possible?
UPDATE
Worksheet 1:
- Worksheet Name: 'Live Forecast Tool'
- Cell containing picklist: C3:D3 (merged)
- Picklist values within range: ='SF MRF'!H5:Y5
Worksheet 2:
- Worksheet Name: 'AH'
- Cell containing picklist: C3:D3 (merged)
- Picklist values within range: ='SF MRF'!H5:Y5
Cell C3:D3 needs to update to show the value that has been changed on the other sheet.