| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Take a list from one workbook and apply asdropdown in another work
I have created a list in one workbook now I want to take that list and apply
it as a dropdown to select which word I want to use in another workbook. How can I do this |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take a list from one workbook and apply asdropdown in another work
<Data<Validation...
Select "List" in the drop-down Enter your list range (from the other sheet) in the "Source" box Does that help? -- Regards, Dave "Nathan" wrote: I have created a list in one workbook now I want to take that list and apply it as a dropdown to select which word I want to use in another workbook. How can I do this |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take a list from one workbook and apply asdropdown in another work
Nathan
You must name the source list. See Debra Dalgeish's site for more on this. http://www.contextures.on.ca/xlDataVal05.html Gord Dibben MS Excel MVP On Wed, 11 Jan 2006 08:48:02 -0800, Nathan wrote: I have created a list in one workbook now I want to take that list and apply it as a dropdown to select which word I want to use in another workbook. How can I do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| How to apply a format to an entire workbook | Excel Worksheet Functions | |||
| Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
