Background Not too long ago, I was approached by a systems consultant to consider writing an Excel solution to create a weekly production schedule for one of his clients.  The reason for using Excel will become clearer in a moment. The current process Sales representatives submit a unique Excel spreadsheet / file for each customer order.  All orders are saved […]