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.
These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2016
(60)
-
▼
April
(60)
- Fantasy Baseball Simulator - Brandon Soderquist
- Nutritious Meal Planner - Dain Berrett
- Equity Stock Ticker: Scraping The Web
- Events Report Automation - Cory Paxton
- Jinsook Lee - Personal Books Organizer: SMART LIBRARY
- Piano Academy Task Streamlining: Executive Summary...
- Riley Preslar MBA 614 Final Project Executive Summary
- Help Finding a Car Erik Berglund Executive Summ...
- Medicare Average Claims Report
- Abnormal Returns Tool - Haidyn Knuteson
- Finding Insurance Pricing Discrepancies
- Red River Medical Reporting
- Special Project P&L update for Business Firm - Col...
- Ben Olpin's Bank Account Tracker
- Kylie Wiser's Bond Charts and Lead List Generator
- Fantasy Baseball Draft Tool
- Clark Cannon Mortgage Rates
- Budget Vacation Dashboard My fiancé and I love...
- Real Estate VBA Project - KSL
- Find Your Dream House
- Networking Reminder Tool
- Daniel Oliveira: Current Events
- Tyler Ravsten Financial Tracker and Account Manager
- Lance Kohler: Foreclosure Analysis Tool
- Craig Goodman: Quick & Dirty Analysis on Rental Pr...
- Automation of Analysis for Quantitative Polymerase...
- Personal Budgeting System
- Label Release Log Entry
- Sherpa Tracking Sheet
- Customer Database
- Variance Analysis Executive Summary
- Property Management Tools: Using Excel VBA to Auto...
- Patient Reminders
- An Improvement on Y-Time For the Benefit of BYU St...
- Beneish M-Score
- Young Women's Lists & Reminder Texts
- Monte Carlo Simulation
- Around the World in a Bajillion Loops - Lee Chang ...
- Automated Freight Quoter for Mity-Lite
- Steve Washenko: Automating Studio Emails
- Allyson Woolsey: Qualtrics API Data Summary
- Dylan Eastman - Koko's Lunchbox Sales Report Autom...
- Walt Disney World Planning - Adam Larsen
- A.J. Bronson - KSL Car Finder
- Generating Month-end Reports
- Event Updates via Email
- John's Copart Scraper
- Personal Stock Tracking Tool
- Medical Services Summary and Payroll Calculator
- WF Credit Card Statement Analysis
- 10-Day Weather Forecast
- Inventory Management System for Home Kitchens
- Marketing ROI Calculator
- Handicap Calculator
- Hot Deals Finder
- Student Information Spreadsheet and Ledger
- Academic Information Gatherer
- Reconciliation Assistant VBA
- Statistical Record Linkage
- Comparing Salaries and Cost of Living based on Loc...
-
▼
April
(60)
No comments:
Post a Comment