D
DP7
Is there any way for me to create a drop down box from a list of data in a
different work from the one the drop down box will be in???
different work from the one the drop down box will be in???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
If you use defined/named ranges, you can.
Apply it in the DV with Allow: List, Source: =MyRange
where MyRange is a defined range
Apply it in the DV with Allow: List, Source: =MyRange
where MyRange is a defined range
D
DP7
Hi, I think I am applying your suggestion wrong. I name the range of cells in
one workbook. I then try to insert the range in the reference box of the list
options in the other woorbook and it still gives me the same error. Could u
please provide a little more detail that could help me along my way. Thanks
once again.
one workbook. I then try to insert the range in the reference box of the list
options in the other woorbook and it still gives me the same error. Could u
please provide a little more detail that could help me along my way. Thanks
once again.
M
Max
The former assumed you meant from other worksheets
For workbooks, try Debra's page at:
http://www.contextures.com/xlDataVal05.html
Excel -- Data Validation -- Use a List from Another Workbook
For workbooks, try Debra's page at:
http://www.contextures.com/xlDataVal05.html
Excel -- Data Validation -- Use a List from Another Workbook