View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk jk is offline
external usenet poster
 
Posts: 109
Default Varying selected cells returning value always to the same cell

I would like to click or select a cell and the value in that cell show up in
another cell. Or in other words anytime I select a cell the value of that
cell will shop up always in the same cell. I could click on 20 different
cells (one at a time) but no matter what cell I click on or have selected
that value will show up in the same cell I chose it to. Something like a
@cell selected, @cell pointer, +cell selected, +cell pointer, etc. I want to
use this in conjunction with an @vlookup. So instead of keying in the number
I am trying to do a lookup on I can just select a cell with that number in it.