Forum Discussion
help with formula & functions (no Macros & VBA)
You might get very familiar with tables. I find it to be a very valuable tool and suspect that many of the tables we use like tax tables only scratch the surface. I have experimented with tables much larger and calling up alpha like names is very successful. I created a large table that I use for tagging entries with very specific storage locations and dates. Of course now I am moving away from very helpful macros which are almost impossible to use in the current anti macro climate.
You are correct Tables are extremely helpful. I use tables to create instructions for storing locations of data used for (in this case payrolls). Once I got used to not using macros , I thought I would migrate in Access, but cant figures out what Microsoft is doing with that app. Even getting Access 2024, is problematic. I tried buying it from Ebay with a download code but was good for one reload.