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!