Excel Macros and Spreadsheets

This section has excel VB macros that I have developed. The datafill routine is designed to automate completion of a spreadsheet which has lots of empty cells that have repetitive data fields.

The Open File routine was designed to extract data from a external file in the same directory, particularly on a sharepoint server.