Creating an itemized list on a sheet based off of cell values on another

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.

Maybe a visual will help... The 'Qty.' and 'Target' columns represent the # of bottles on hand vs. the target inventory #, respectively. As a flag, I will subtract items in column G from those in H - So, if my target inventory is 5 and I have 3 'Qty.' on hand, then I will want to pick up two of whatever item that is.

liquor.JPG

I'd like to be able to take only those items, and create a list I can print to take shopping. So, in the above example, lets just say I need 2 bottles of the 10 yr. 750ml size, and 1 bottle of the 21 yr. 1.75L size (which I realize they probably don't even make in that size, but that's not important for the example). So then my intention would be to have a separate sheet that automatically pulls those two items and creates a list like so:
Name Size Price #-to-purchase
Bushmill's 10 year 750ml $XX.xx 2
Bushmill's 21 year 1.75L $XX.xx 1

Not present would be all the items I don't care about for this scenario, such as the other Bushmill's varieties, or whatever else.

Originally Posted by FDibbins

can you upload a sample workbook for me to look at please? im sure we can come up with something for you

Indeed. Thanks for the help! I seem to know just enough to get in over my head, but I'm willing to learn whenever someone's gracious enough to impart some wisdom

liquor_.xlsm