| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
