Excel exports of report data - don't suppress duplicate cells
Microfiche
Quicken Canada Subscription Member ✭✭✭
Not sure if I am explaining this correctly - but I spend a LOT of time adding back information to Excel exports to make them useful, mostly on reinvested dividends and share sales where the transactions are shown as 2 lines - there are other types, I just don't recall at the moment.
As shown in the screenshot below, the date, account, and security are not included on the second line of the those transactions. When I export them to analyze data, I have to add them all back in - not a small feat when there are hundreds or thousands of transactions.
It would be lovely if there was an option to save me that trouble. While a "suppress if duplicated" option is great in reports, it is not useful in spreadsheet exports.
Using Quicken since sometime before the beta test of Quicken 6 for Windows in 1996...
Tagged:
1