| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a sheet from a drop down box
nice, thank you =)
"Debra Dalgleish" wrote: There are instructions and a download here for creating a toolbar that lists the sheets in a workbook, and activates the selected sheet: http://www.contextures.com/xlToolbar01.html Bonbon wrote: sorry, this is really good. However what if, there is an update in names? Because i want to do something like this too, but im using Dates, and i will keep adding/updating, so is there any way for Excel to auto update the list of Dates in the combo box + opening the chosen worksheets??? Thx in advance, Bonbon "Florida User" wrote: An easy solution would be add a worksheet that is the master list of players and then create a hyperlink to each worksheet. Insert Hyperlink Place in this Document Select the worksheet Change the Test To Display to the player's name On each player's worksheet you can add a hyperlink to return to the main sheet with your list of players. When you create this link once you can copy it to each worksheet. Hope this helps "Caveman" wrote: I have a list of cricket players names (26) each has thier own spreadsheet with all thier info on it (batting averages, etc.etc) can i use a drop down box with thier names in to open the sheet with all thier info in. -- Caveman ------------------------------------------------------------------------ Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546 View this thread: http://www.excelforum.com/showthread...hreadid=505120 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Selecting from a Validation Drop Down Box aborts macro | Excel Worksheet Functions | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Threaded Mode
