Basically, on one page I have some fields with a simple data validation "List from a range", which gets its items from some fields on another page. When I update the values on the second page, it does update the validation drop down, but doesn't change the field on the first page.
Is there some way to set it up so that when I choose a value on the first page using the data validation drop down, and then change the value on the second page, it updates on the first?
I assume from what I've been looking up this needs some kind of macro, I was wondering if it was possible to have a dropdown, that when you select a value in the list, it inserts a reference (i.e =A1) instead of the raw value.
Update: Alot of the searching I've done has turned up results for basic data validation usage, And I'm not sure if what I'm asking for even is just validation at this point, but the closest I've found to what I'm looking for is this unanswered question: https://stackoverflow.com/questions/50271882/changing-data-validation-source-values-does-not-update-cells-using-the-original
Update 2: Here is a dummy spreadsheet with an example, and a small explination (as well as a hacky workaround I came up with, which might give you an idea as to what im trying to do)