Macro – Inventory Report automated

Published on Saturday, September 26, 2009 by Chris

The inventory report shows the total quantity of stock required to be purchased for each part or inventory id. The inventory id total quantity is determined by a pivot table and also with the use of a sum if formula.

Feel free to download and see how the macro operates.