Forum Discussion
Kit Dunagan
Aug 17, 2018Copper Contributor
Is this even possible in excell?
My question is: Is it possible to have a cell display a value of a referenced cell while also allowing you to modify that referenced cell by typing into the cell that's showing the other cells value....
Philip West
Aug 17, 2018Iron Contributor
If it's all in the same workbook it /might/ be possible with VBA but I'm not sure it would be practical.
I don't have the knowledge to write it, maybe someone else can point you in the right direction.
I have a feeling that doing that for '00s of items, and maybe '000s of cells wouldn't run very well.