Forum Discussion
Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)
Depending on what your desired end goal is, those lists of account transactions--I'm assuming that you're looking at some summary or extraction of a defined sub-set of data from the comprehensive database--you might find it more suitable to use a few of the Dynamic Array functions. Let me direct your attention to FILTER, UNIQUE, SORT. Also, this probably could be used to create a "custom" Pivot Table, PIVOTBY. I haven't used this last function yet; I have used the first three extensively, and found it very easy to create custom extractions of data on the spot, with (yes) a lot more flexibility than the Pivot Table tool itself gives you.
Hmmm....At least I'm predictable in a way that I approve.😉
I'll reiterate that the BudgetPivot sheet is really a simple example, far simpler than those other two that you've seen. But to a great extent that simplicity is precisely because Pivot Tables are simple, yet can work with and helpfully summarize massive (transactional or other) databases.
My guess is that those two extra features of your monthly sheets status quo--each bill's paid amount and date, as well as the virtual savings accounts--especially the former, could easily be incorporated into a single database. The latter--those virtual savings accounts--might warrant their own but still single database.
Welcome to the ranks of the retired; I joined that happy company in late 2002, nearly a quarter century ago. Since you're now retired, I'm going to assume you're in your 60s...so maybe you were around when Pivot Tables (and spreadsheets) were in their toddlerhood, as was I. I actually was writing my own programs in the early 1970s, creating and manipulating multidimensional arrays (using the APL programming language), so spreadsheets like Lotus and Excel (along the way VisiCalc and Quattro) were welcome shortcuts. That's one of the reasons I look at things from a basic design perspective.......