| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the source in data validataion be located in another sheet?
If I am creating a drop down list in Excel using Data Validation, can the
source part be located in another worksheet? I would like to put a highighted range in the source box instead of typing in values/text. Also, if I add items to the original list on the other worksheet or edit them in any way, will my list box reflect this update? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resize Validataion Message Help! | Excel Discussion (Misc queries) | |||
| Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Automatioc spill over data to a new Excel sheet from Xml source? | Excel Discussion (Misc queries) | |||
Threaded Mode
