Portfolio

VBA, Excel

(Access - Coming Soon)

VBA Projects

I taught myself how to code in VBA. There were a couple of tasks at work that I felt could be automated and so I began to build as needed. At first, I would simply copy what I found on StackOverflow, but as I began to understand more, I was able to write my own projects from scratch. Most of my VBA experience is in Excel, but I do have some VBA experience in Access, Outlook, and Visio.

Excel Table Scraper

General Purpose

Grabs DataBodyRange of all Excel tables in workbook (visible and hidden) and places the information in a worsheet at the end called "Values". Uses the longest header row of all Excel tables in the "Values" worksheet.

Saves hours of work when receiving recommendations from multiple divisions.

View Source Download

Merit Increase Planning - Data Validation

Compensation

During Merit/COLA planning, managers can enter either the amount increase or the percent increase and the other item will change accordingly.

Ensures accuracy of recommendations submitted and saves manager from headache of checking calculations.

View Source Download

Workbook Cleanup

General Purpose

Multiple small macros used to:

  • Replace INDEX/MATCH, VLOOKUP, SUMIFS, etc. formulas from ActiveSheet to avoid broken links.
  • Collapse all grouped columns in every spreadsheet. Also moves view to top and leftmost cell.
  • Clear Names and Conditional Formatting.

I use this daily! Saves time from repetitve, boring tasks!

View Source Download

Excel Projects

I taught myself how to use Excel, and picked up some tricks from fellow co-workers along the way. I started with simple budget spreadsheets in my personal time and worked my way to larger lookup formulas at work. I often take the opportunity to learn how to do something more efficiently whenever there is a new project. I also learned from creating spreadsheets that I would later have to send to other people to be mindful of designing the spreadsheet so it could walk on its own two feet.

Rubik's Cube Scrambler

Personal

Used to study certain solve cases, this shows what a cube looks like after scrambling a certain pattern.

Helps in learning blindfold solving.

Download