Forum Discussion
How can I use text input to copy a another cell dynamically?
I am seeking a way to create a rule to assist me with schedule readability. I want to enter a "B" into any cell and have the cell to automatically populate with the corresponding information contain...
Hello,
Excel cells can contain either a formula or a value. If you enter a value into a cell, it cannot automatically change to a formula that pulls data from somewhere else. But you can enter a value into cell P5 and then let the next column use a formula that pulls the value.
If you don't want to use that approach, you will need VBA to replace the B with the desired value. Are you happy to use VBA?