Jan 11 2019 08:03 AM
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
Jan 11 2019 09:42 AM
SolutionHi Carlos,
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[#Headers]") and =INDIRECT("Subcategory[" & INDIRECT("Transactions[@Category]") &"]")
Jan 14 2019 02:48 AM
May 19 2019 02:11 PM
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?
May 27 2019 06:25 AM
Hi, more or less.
I had to make a workaround and use it in a simple way.
But the solution above was my guide.
Jan 11 2019 09:42 AM
SolutionHi Carlos,
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[#Headers]") and =INDIRECT("Subcategory[" & INDIRECT("Transactions[@Category]") &"]")