This program analyzes an annual credit card statement (in .csv form) using a downloaded template from Wells Fargo. The statement template contains seven column fields including a "master category" and "subcategory" fields. The program contains two executable procedures that are activated by clicking its respective button. The first procedure allows the user to edit the active cell row with a user form. Only the master category and subcategory are allowed to be changed to enable the user to re-categorize transactions. The second procedure creates a pivot table that sums the amounts for the master and subcategory fields and generates a chart for comparison. The purpose of this program enables a quick and easy analysis of a Wells Fargo credit card statement.
No comments:
Post a Comment