| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refer to drop down item as a sheet reference in a formula
I want to use a drop down list of names to cause the formulas in excel to
look on a sheet in the same work book with the same tab name as the drop down name chosen and place the data found in a particular cell in the appropriate cell on the sheet with the drop down. Each of the other sheets are data concerning only one name per sheet. I am using 2003 version in xp. I hope this makes sense to whom ever would like to field the question. Thanks! Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Threaded Mode
