| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Link in a Drop Down - Where does it get its data?
I inherited an Excel workbook that has an issue I cannot crack. I have a drop
down box that allows the user to select a date week from a reference sheet. Next to that column that feeds the drop down, is a week number (1-52). The cell link on the drop down lists a cell to which to write the cell week number. My question is, if the drop down cell range is 'Data Page'!$B$3:$B$54 and the Cell Link is 'Data Page'!$H$2, how does the Cell Link know to put the week number which is located in 'Data Page'!$A$3:$A$54? The Cell Link seems to only specify the place where to put the data, not which data to put there. Thanks for your help! -- Dr. M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link 2 data sets to 2 drop down menus? | Excel Worksheet Functions | |||
| How to link a drop down value to a cell in a different worksheet? | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| How to link data from one drop-down list to another | Excel Worksheet Functions | |||
| in excel I want to set up a drop down & link that to another cell | Excel Worksheet Functions | |||
Threaded Mode
