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
|