I have an inventory sheet I'm working on, and a primary function of it I would like to implement is a way to create a shopping list and print it. The inventory sheet has a qty on hand field, and also a target inventory field - subtract the latter from the former and you have a number of that item that should be purchased on the next shopping trip. I'm assuming it will take some VBA functionality to pull those items (including other pertinent fields such as the item name, size, price, etc.) and place them on a new sheet to create a list. There are a lot of SKUs, enough that I'm trying to pull only the items that need to be purchased to create the list and avoid either a lot of excess white space, or having every item on there including the ones that don't need to be. Hope I'm made that clear enough....

I am comfortable with trying to implement some VB, but I'm not that familiar with it - so if anyone has suggestions on how to do so I would really appreciate it.