Samples of My Work (Excel/vba spreadsheet design)
For over a decade, I've done contract work, creating MS Excel tools using
Visual Basic for Applications (vba) coding. See my resume for details of my experience,
references, etc. To view a sample of an Excel tool I created (from a 2008 contract with Gap Inc), follow the steps below.
Email me if you'd like to see more extensive samples, or for further explanation.
I'm currently available for new projects.
1)
RIGHT CLICK on the Download Now link below, select "Save Target As...," and save
the file Q1_fcst_dummy_data.xls to your hard drive.
2)
Open MS Excel. Make sure the security is set to Medium
(from the main Excel menu, choose Tools, Macro, Security, Security Level,
Medium).
3) From the
main Excel menu, choose File, Open and open the Q1_fcst_dummy_data.xls file. You must choose to "enable" macros when prompted.