Thank you for your input, Aphylis.  Intuit host our QB Enterprise, Excel is an addition cost.  Also, I'm not so great with pivot tables.  One would think with Advanced Inventory, on any given day that I could see how many of what lot number I have (or had) at each site.  I primarily use this info to compare physical inventory counts with what is in QB at the end of the month.  Several warehouse managers turn in the counts at that time and it is much easier to go back to that Site manager and say "you're off on Lot # ___".  We changed to Enterprise because of this Lot# and Site feature.  Had I known how many hoops I'd have to jump through to get these basic numbers, I would have stayed with the system of making each lot # it's own item  and saved the money of upgrading.  Thanks for letting me vent.