| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add data t drop down list use a different worksheet same workbook
If you name the list, you can refer to it in data validation on a different
sheet. There are instructions he http://www.contextures.com/xlDataVal01.html If the list will change size, you could use a dynamic name, as described he http://www.contextures.com/xlNames01.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Drop down list" wrote: I want to add a value in a drop down list and I use a different worksheet in the same workbook How do I process to allow me to have all the value in my worksheet. I cannot see the new date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| how to restore disappeared drop list of data validation? | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| linking data between sheets using drop down list | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Hybrid Mode
