Hi,
I have two fields
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.
Could someone please advise!
Thanks in advance!
