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.
Mathetes - I have created a short database and initial (very basic) pivot table, but now I remember why I didn't use them much when I was working - formatting them exactly as I want (and can in excel) is not intuitive to me. So I'd like help on cleaning up the pivot table to get close to matching the lists of account transactions in my current workbook.
Aince my original question, getting hyperlinks to work in copied worksheets, has been answered, should I end this thread and start one for cleaning up my pivot tables?
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.
While I was working on cleaning up the pivot table, I was also working on using FILTER, which seems to be a good solution. I'll continue down both paths and see which one works best long-term.
I'll tag this string as "answered", since it was originally about hyperlinks. Thanks for your help!