VBA Programmer

Position Details: 
VBA Programer

Help the Trail Conference with your amazing VBA Skills!

This volunteer opportunity will allow you to not just apply your VBA programming skills, but also to use them to facilitate the daily balancing of the books in our busy back office.  Learn the details of how that is accomplished, and then automate the process so it is quick, easy, and accurate!  We need you to upgrade an existing Excel VBA macro to make it a fully functional program  -  flexible and robust.  Bring the code up-to-date with Office 2007 or 2013.   The finished program will operate on three files: a hiking book and map sales file, a membership payments file, and a file of paypal charges, spanning multiple days.   They will be copied in to one master worksheet, then divided up by day and copied to one worksheet for each day.  The code will loop through the map sales file, one entry at a time, and find the matching entry in the paypal file, based on customer name and amount.  It will repeat the process for the membership payments file and the paypal file.  Matching  and mis-matching entries will be flagged with appropriate letters.  A detailed string name comparison will be done for the names in the files resulting in two or three levels of "match" which will combine with the match flag for amounts to create a multi-tiered, more exact, matching scheme.   When the Excel project is complete, the daily and weekly bookkeeping for our sales department will be accomplished with just a few mouse clicks  - then we will all have more time to go out and hit the trails! And more projects can follow for the successful and interested programmer.  
Program Area: 
Gary Willick
Posting Date: 
Location Type: 
Off Trail
Sign up for VBA Programmer
An e-mail address is required for users who are not registered at this site. If you are a registered user at this site, please login to sign up for this Volunteer Opportunity.


It's our priority to make sure you have all the skills you need to safely enjoy your volunteer experience with the Trail Conference. In order to do that, we need to know a little more about you.

Have you ever volunteered with the Trail Conference?


To help us ensure this volunteer opportunity is the best match for your skills and interests, please select one of the following options to begin your volunteer experience with the Trail Conference:

Thanks! Your interest will be reviewed and we will follow up with you in the next few days.