Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet with around 100 entries in one sheet related to a hotel's rate contracts. Each contract (entry) covers around 30-35 lines. I have already defined the print areas and I have named them accordingly. I would like however to create a drowdown menu at the top of the sheet, from where I could pick up the name of the contract and from there the equivalent contract (as defined on the print area) to appear at the top of the sheet - something like a hyperlink. Can anyone help please? Thanks a lot in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions |