I keep getting a "The Source currently evaluates to an error. Do you wish to continue?" error. I click Yes and then try the drop down and nothing appears.
Also, I have attached an updated version of the file. I'm very sorry - I forgot to add another little hitch in the problem. I have another tab for classes. It is pretty much the same exact situation as the Contacts. When the user chooses "January One" in column A of sheet1, only the January One Classes should populate in the column D drop down.
Will I have to change the naming convention since "JanuaryOne" is already the name of the JanuaryOne contacts list?
Thanks again!
Bookmarks