they both have the same values but they are looking at different fields.
Field 1
Field 2
123
123
124
124
125
125
126
126
When a value for field1 is selected in sheet 1 I want it to display the selected value for field 1, however if I navigate to a different sheet I want it to change to the same selected value but for field 2. And then when sheet 1 is slected again for it to revert back to the orignial field 1.
