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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the source in data validataion be located in another sheet?
Yes, but you need to name the list, assume it is in Sheet2 A2:A50, go to
Sheet2, select A2:A50 and in the name box type in a name like List1 or something (or select the range, then do insertnamedefine and type in the name) then refer to it as =List1 in the list source box -- Regards, Peo Sjoblom "trainer07" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the source in data validataion be located in another sheet?
Peo addressed the first part of your question, but to add items to the list you
would have to make it a dynamic range. From Debra Dalgleish's site.......................... Some lists change frequently, with items being added or removed. If the list is the source for a Data Validation dropdown, use a dynamic formula to name the range, and the dropdown list will be automatically updated. For instructions, view this page: http://www.contextures.on.ca/xlNames01.html#Dynamic Gord Dibben MS Excel MVP On Thu, 10 May 2007 11:49:02 -0700, trainer07 wrote: 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! |
Reply |
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) |