I have 2 sheets - Data and consultant. Both have a column labelled 'Status' (orange cells) These show the status values of each ID (green cells). The status cells have a data validation dropdown.
Currently the consultant sheet looks up its status value from the data sheet, based on the selected sales consultant.
I would like to edit the spreadsheet so that if the user changes the Status cell drop down value in either the Data or consultant sheet - both sheets will update the appropriate status value for the ID (column C).
Is this possible?