Associate
I'm pretty sure that something like this isn't possible (without custom coding it myself somehow) but maybe I'm wrong.
I'd like to link two (possibly more) cells together so that their values are all exactly the same.
The catch, I'd like to be able to edit said value from any of the linked cells.
Having a master value, and referencing that in each of the linked cells wouldn't work. (again, to my knowledge)
(backstory: I'm creating an app, using excel (wasn't my choice) and while I'd like to use something else, I get stuck with either not being able to store/interact with the data in a sane manner and creating a UI, so I've been soldiering on using Excel. It works... thats about all thats going for it...)
I'd like to link two (possibly more) cells together so that their values are all exactly the same.
The catch, I'd like to be able to edit said value from any of the linked cells.
Having a master value, and referencing that in each of the linked cells wouldn't work. (again, to my knowledge)
(backstory: I'm creating an app, using excel (wasn't my choice) and while I'd like to use something else, I get stuck with either not being able to store/interact with the data in a sane manner and creating a UI, so I've been soldiering on using Excel. It works... thats about all thats going for it...)