Order Tracking and Invoicing Spreadsheet

2017-10-15T14:48:30+00:00

Order Tracking and Invoicing System We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their factory. Information from the arrival package was scanned into the system and the relevant information extracted and stored in an [...]

Property Portfolio Management Spreadsheet

2018-02-19T20:34:11+00:00

Property Portfolio Management Spreadsheets Using Excel Dashboards, we built the property portfolio workbook for an estate agency, to help them to keep track of their clients’ property portfolios and investments. The idea  […]

Daily work orders updated automatically in Excel

2018-02-19T20:34:59+00:00

Daily work orders updated automatically in Excel Drawing data from one spreadsheet and inserting it into another spreadsheet is a very common and time consuming process in the business environment.  A process that can be speeded up considerably using vba to automate the process.  This is easier the more standard the [...]