Hello,

I'm not quite sure what this function would be called, but this board has always been great at answering my questions. Basically what I need is Data Validation from a list that changes a cell value on another tab, but on the other tab I can also click that cell and change the value from a drop down, changing the original cell.

So if cell A1 was changed on tab 1, cell A1 on tab 2 would be changed. But I also need th opposite to work when changing cell A1 on Tab 2, changed the value of cell A1 on tab 1.

Basically Mirroring the data from a drop down menu on two tabs.

Thank you