Mar 01 2019 12:05 PM
I have a couple tables that I'm using as the source for some Data Validation drop down menus. If I want to add items to these tables and have them automatically update in the drop down menus, I'm having to insert the items somewhere below the first cell and above the last cell. If I try to insert an item above the first item or below the last item (even though it's still in the "table" and the table automatically expands), those items don't update in my drop down menu. Why is this? Is there something I can do to make this work?
Mar 04 2019 10:16 AM