Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dropdown with a "jump to" cell name. Like a Go button..
I have a large spreadsheet that is long in length. I must scroll until I find
that employee's info, sometimes 5-7 pages down... Is there a way to use a DropDown that selects from my list of names then "hyperlinks" me to the names cell in on the sheet.? thanks |
#2
|
|||
|
|||
Some relatively simple options:
Select the column with the name in it, go to Data, then Filter, and select Autofilter. This will put a little red caret/arrow on that column with a dropdown of all the various data in that column, you can select the name you want and all records with that name will come up. To undo and view the sheet normally, just go back to Data and uncheckmark the Autofilter. Another way, which you've probably tried, is to do a Find (either ctrl+F or on the Edit menu, do a Find). Then again, you'll have to keep entering on that FIND to get all entries with that name. "thom hoyle" wrote: I have a large spreadsheet that is long in length. I must scroll until I find that employee's info, sometimes 5-7 pages down... Is there a way to use a DropDown that selects from my list of names then "hyperlinks" me to the names cell in on the sheet.? thanks |
#3
|
|||
|
|||
Thanks for the reply: ..
This works, however each person is only list once. Each person has several rows of data that I need to look at. The autofilter is only showing me ONE line.. I guess I could add that users name in the column next to each line of data that is there's and then the autofilter will find that users info... I'm hoping to get more of a VLOOKUP with HYPERLINK using a pulldown.. I found a place on the web that describes this... but too confusing for me.. please view: http://www.mrexcel.com/archive/Formulas/19517.html thanks "Nicole L." wrote: Some relatively simple options: Select the column with the name in it, go to Data, then Filter, and select Autofilter. This will put a little red caret/arrow on that column with a dropdown of all the various data in that column, you can select the name you want and all records with that name will come up. To undo and view the sheet normally, just go back to Data and uncheckmark the Autofilter. Another way, which you've probably tried, is to do a Find (either ctrl+F or on the Edit menu, do a Find). Then again, you'll have to keep entering on that FIND to get all entries with that name. "thom hoyle" wrote: I have a large spreadsheet that is long in length. I must scroll until I find that employee's info, sometimes 5-7 pages down... Is there a way to use a DropDown that selects from my list of names then "hyperlinks" me to the names cell in on the sheet.? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using a button in a cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |