Re: exporting category list by Dick
Dick
Sat Feb 21 23:19:39 CST 2004
IF you want to get categories that have been used in transactions, probably
the best way is to use MoneyLink to pull all transactions for all dates for
all accounts into Excel. From there, simple spreadsheet manipulation can get
you there along these lines:
1) Copy the category/subcategory columns to a new sheet.
2) Sort the entries on Category and Subcategory.
3) Create a formula to only show the Category/Subcategory if it's not what's
in the next row.
4) Copy the unique resultant column(s).
5) Paste Special|Values this to a new column.
7) Sort it again on these values to get the entries at one end and the
blanks at the other.
8) Select the entries. Done.
"GCooper" <sfsdf@srsrf.com> wrote in message
news:uP7MsLE%23DHA.4088@tk2msftngp13.phx.gbl...
> How do you export the category list in Money 2004? Thanks.
>
> Glenn
>
>