I have a table that contains a list of information that I want to use to fill two columns in another table.
Table1 has headers that I'll use in the first data validation list;Every header contains information that will be used on the second data validation list;
This second data validation list depends on the first one value to bring possible entries;
I've created specific names on Name Manager to make it easier;
Everything is working fine, except for the fact that the new rows I add to the table, will have a reference for the first row instead so;
No matter the value of the row, it will always use the 1st row as reference.
Can someone help me? :D
View best response
I guess that's since your names were not updated when you modified first table. Instead of names I'd suggest to use references on tables
=INDIRECT("Subcategory[" & INDIRECT("Transactions[@Category]") &"]")
Hi, did it work for you? I am also facing similar problem and unfortunately i am not that proficient and expert in Excel as you.
Could you please share, how you handled the problem?
Hi, more or less.
I had to make a workaround and use it in a simple way.
But the solution above was my guide.