View Single Post
  #1   Report Post  
Anthony Slater
 
Posts: n/a
Default Populating a cell when certain cell is clicked

In sheet 1, A1:A100, I have a list of serial numbers. The rest of the sheet
contains various information
In sheet 2 A1, I have a drop down list (using A1:A100) and then VLOOKUP's to
pull information from sheet 1.

So far so good

Is there a way of eliminating the drop down and populating the cell in sheet
2 by just clicking on the required number in sheet 1 A1:A100 ?

I know a hyperlink can take me to sheet 2 but not the value of the
hyperlinked cell

Any ideas?

TIA