| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referencing Sheet Tabs
Is there a way to use the "value" of a name in a drop-down list to reference
a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's Sales) is selected from the drop down list, B1 shows the value of cell D5 from sheet "Bob's Sales". Thanks for your help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
| is there anyway in an excel macro to reorder the sheet tabs from left to right? | Excel Worksheet Functions | |||
| data from one sheet to several in sequential order! | New Users to Excel | |||
| How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
