This summer I helped a client automate several Excel sales reports, comparing sales forecasts to actual sales, and last year's results to this year's. It's a complicated process, pulling numbers from different systems, updating lookup tables, compiling the numbers, and creating reports by product, by customer and by sales rep. Before we automated the process, [...]