Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Refer to seperate workbook for validation list for drop downs?
Id like to keep my validation data for drop downs in a seperate workbook so
that many users/worksheets can reference it. However- data validation doesnt seem to let me reference named ranges in a seperate workbook- any advise out there? -- Dee |
#2
|
|||
|
|||
Visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal05.html But take note that the other workbook has to be open. Dee wrote: Id like to keep my validation data for drop downs in a seperate workbook so that many users/worksheets can reference it. However- data validation doesnt seem to let me reference named ranges in a seperate workbook- any advise out there? -- Dee -- Dave Peterson |
#3
|
|||
|
|||
http://www.contextures.com/xlDataVal05.html
-- Regards, Peo Sjoblom "Dee" wrote in message ... Id like to keep my validation data for drop downs in a seperate workbook so that many users/worksheets can reference it. However- data validation doesnt seem to let me reference named ranges in a seperate workbook- any advise out there? -- Dee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
view list of worksheets contained within a workbook | Excel Worksheet Functions | |||
How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
List Box refer to an array | Excel Discussion (Misc queries) | |||
printing the list of wroksheets in a workbook | Excel Worksheet Functions |