pleased2help
New member
- Joined
- Jun 27, 2013
- Messages
- 28
- Reaction score
- 0
- Points
- 0
Is there a formula in Excel 2010 to return the cell ref of another highlighted cell ie:
If I move the cursor to cell "C1" and enter to select it
cell "B1" would show "C1" or better still the value in cell "C1"
If I then move the cursor to cell "C2" and enter to select it
cell "B1" would show "C2" or better still the value in cell "C2"
I would only need to do this for a range of cells "C1 to C14"
Many thanks Paul
If I move the cursor to cell "C1" and enter to select it
cell "B1" would show "C1" or better still the value in cell "C1"
If I then move the cursor to cell "C2" and enter to select it
cell "B1" would show "C2" or better still the value in cell "C2"
I would only need to do this for a range of cells "C1 to C14"
Many thanks Paul