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.