Hi there,
I am updating the Categories table. The data in this table in the Sub Categories column acts as a list in the worksheet Bank TransactionsFinal.
I am finding that the table is not automatically updating when I add to it? I have the table set to update automatically??
I'm finding that because the table is not updating, my List in SubCategories in Bank TransactionsFinal is not updating eithere.
Any suggestions on how I can correct the Table to update?
I look forwatd to any suggestions
Thank you
Chris
When you point a data validation (DV) list to a column of a structured table on the same sheet as where you create the drop-down it will work as you expect, even though the reference that Excel creates looks like an old fashioned absolute range.
However, when the DV list in on another tab it will NOT work. You must first create a named range to the column with the Sub categories (i.e. in column B). Done that and called it "SubCat". Then pointed the drop-down to =SubCat and all works fine. Add a sub-category at the bottom
and it will show up in the drop-downs on the bank details tab.
By the way, I notice you already have a named range called SubCategory, though it's pointing to the Category column in the categories table. Not sure what your intentions are with that one.