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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refer to drop down item as a sheet reference in a formula
If I understand you correctly...
Assume dropdown in A1, and the "particular cell" on the sheets is J10. =INDIRECT("'" & A1 & "'!J10") In article , "milkman" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refer to drop down item as a sheet reference in a formula
JE McGimpsey, That was the answer to my problem. Many Thanks.
I do have one more issue now. When I try to fill series in the columns the fixed ref increases by 1 step instead of the variable ref (the one for the data base for the name chosen). Would appreciate help with this. Otherwise thanks again and have a good day! Ed "JE McGimpsey" wrote: If I understand you correctly... Assume dropdown in A1, and the "particular cell" on the sheets is J10. =INDIRECT("'" & A1 & "'!J10") In article , "milkman" wrote: 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. |
Reply |
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 |