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 structure of the data sets, but this does not have to be a limiting factor. It simply makes coding a little more complicated.
In a recent example, the client had been receiving daily work orders from their client, and would then have to manually match the orders to the individual engineers in the company. Excel is very good at matching, and had no problem doing this process automatically. This project probably saves our clients over 2 hours a day.