http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset
So I am racking my brain. I keep getting an error “the list source must be a delimited list” when trying to do sub-2.
And the bizarre thing is I even manipulated the Sample File to match 100% what I have on mine. It works… but, on MY file, I get the error. The formulas in the Name Managers match exactly. I have the table names matching. I have the sheet names matching. The table data matches. Yet on mine, I get the error.
Yes, I could just keep the manipulated file as my running file. But, just like most on here, I want to learn and figure out where I am going wrong.
Give a man a fish – he eats for a day. Teach a man to fish, he eats forever.
Anyone know where (probably stupidly) I went wrong?
Attached is my example, and FGH are of the first tab are where I want the drop downs.
***I used the template (from the link above) and transferred my data into the created tables. I renamed the tabs to match mine. I renamed the tables to match mine. And I moved the table/cell locations to match mine. And it worked. My Name Manager formulas matched exactly. However, the odd thing is, on the example I downloaded - although it worked - IF I were to clear the validation - and redo it .... I would get the error. But, if I left it alone, it would work.... bizarre stuff.
So I am racking my brain. I keep getting an error “the list source must be a delimited list” when trying to do sub-2.
And the bizarre thing is I even manipulated the Sample File to match 100% what I have on mine. It works… but, on MY file, I get the error. The formulas in the Name Managers match exactly. I have the table names matching. I have the sheet names matching. The table data matches. Yet on mine, I get the error.
Yes, I could just keep the manipulated file as my running file. But, just like most on here, I want to learn and figure out where I am going wrong.
Give a man a fish – he eats for a day. Teach a man to fish, he eats forever.
Anyone know where (probably stupidly) I went wrong?
Attached is my example, and FGH are of the first tab are where I want the drop downs.
***I used the template (from the link above) and transferred my data into the created tables. I renamed the tabs to match mine. I renamed the tables to match mine. And I moved the table/cell locations to match mine. And it worked. My Name Manager formulas matched exactly. However, the odd thing is, on the example I downloaded - although it worked - IF I were to clear the validation - and redo it .... I would get the error. But, if I left it alone, it would work.... bizarre stuff.