ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Creating a dynamic dropdown from closed workbook (https://www.excelbanter.com/links-linking-excel/445957-creating-dynamic-dropdown-closed-workbook.html)

selseyr May 3rd 12 02:40 PM

Creating a dynamic dropdown from closed workbook
 
Hi
I am trying to create a dynamic dropdown that refers to a closed workbook. I found a great thread on this website that referred back to 2006

http://www.excelbanter.com/showthread.php?t=76750

however, when I follow this through my dropdown shows zeros at the bottom of the dropdown list from where it is allowing there to be future values. Can anybody tell me how to format it so that if there is no value it truncates the list.

the other way I have tried is not adding the new values if they are added to the original list

Many thanks. I am struggling here!


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
ExcelBanter.com