I'm about to hire a guy to do some deliveries for me, and I want to be able to hand him a summary off all the invoices, at the start of his day.
I can make it in excel, but it seems like too much work to do on a weekly basis.
What I would like is customers on the left and the different products accross the top. At the bottom of each column would be the total number of that product needed to complete delivery of all the invoices. This way at the start of the day, we can confirm on one set of numbers, rather than loading based on each invoice.
Thoughts?
A