philipjsmith
New Member
- Joined
- May 19, 2002
- Messages
- 20
How to you get Excel to copy into the active cell whatever happens to be in the cell above? If you know the cell above contains a numerical value how do you use this value in a formula in the active cell ( say for example you wanted to halve it ) & if you know the cell contains text how do you copy that text into the active cell?
And suppose that cell is not above but say 3 cells up & 2 cells to the left? Can it still be done?
(Without using VBA)
And suppose that cell is not above but say 3 cells up & 2 cells to the left? Can it still be done?
(Without using VBA)