Credit Migration Report
Corporate & Institutional Bank
This manager co-ordinated a team of 12 analysts to produce monthly reports for senior management – including the board of directors – for a major bank.
One report required a 150 megabyte text file from which an analyst copied-and-pasted individual values to produce a matrix.
This manual, error prone process consumed about 3 ½ hours.
The solution was to import the large text file into MS Access.
Each datapoint in the report required a separate query, so a generic query was written which accepted various parameters. The parameter values were stored in the cell to receive the data. Users used a dedicated screen to edit the queries as required.
The report which previously took 3 ½ hours to prepare, now took about 20 seconds.
MS Access, Excel, VBA
* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.
PROFESSIONAL PROJECT PORTFOLIO
Get this FREE Portfolio of VBA Projects
Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.
Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.
Click the Download button to get instant access to this project summary as a PDF you can print or share.
BENEFIT FROM EXPERIENCE
Save time, money & stress
Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.
Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.