Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link two worksheets thru a scroll-down bar?
Dear All, I hope someone can help me. I want to have in one spreadsheet a
scroll-down bar where I can select one and only one name from a long list. This list is conncted to a second spreadsheet where I have in the first column all the names that appear in the scroll down bar of the first spreadsheet, and in the following columns info about each one of the names. When in the first spreadsheet I select one name I want there, in the first spreadsheet, to appear the info contained in the second spreadsheet about that name. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link two worksheets thru a scroll-down bar?
Look up VLookup in Help. HTH Otto
"Edoardo" wrote in message ... Dear All, I hope someone can help me. I want to have in one spreadsheet a scroll-down bar where I can select one and only one name from a long list. This list is conncted to a second spreadsheet where I have in the first column all the names that appear in the scroll down bar of the first spreadsheet, and in the following columns info about each one of the names. When in the first spreadsheet I select one name I want there, in the first spreadsheet, to appear the info contained in the second spreadsheet about that name. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link worksheets with specific criterias | Excel Discussion (Misc queries) | |||
Link worksheets | Excel Worksheet Functions | |||
Repairing link roots when moving worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
How to link two different worksheets together in Excel | Excel Worksheet Functions |