hedgeman50
Board Regular
- Joined
- Sep 20, 2002
- Messages
- 76
How do I have the contents of a cell equal the contents of the currently active cell (i.e., the cell currently selected)? I have a long list of stock symbols (about 3,000) in column 3. I want to be able to simply hit the down arrow key to get to the next cell and have the cell K3 always have in it the contents of the active cell.
Example: If the active cell is A1 (and let's say that A1 has the symbol MSFT in it), then I want K3 to have MSFT in it. If I move to cell A6 (with the arrow key or with the mouse) and it has INTC in it, then I want K3 to have INTC in it.
Thank you very much for any help!
Example: If the active cell is A1 (and let's say that A1 has the symbol MSFT in it), then I want K3 to have MSFT in it. If I move to cell A6 (with the arrow key or with the mouse) and it has INTC in it, then I want K3 to have INTC in it.
Thank you very much for any help!