Complex problem involving moving rows and returning different values from same criteria

Hello brilliant Excel users, I have a bit of a complex problem that I need some help with. I use Excel 2013 to track my inventory. Sometimes I purchase the same item for different prices. An example of my "Current Inventory" spreadsheet is below:

Item --------- Buy Price ---- Quantity
Apple Ipod ------ 150 ---------- 1
Apple Ipod ------ 175 ---------- 1
Apple Ipod ------ 175 ---------- 1
Electric Fan ------ 10 ---------- 1
Electric Fan ------ 15 ---------- 1
Electric Fan ------ 15 ---------- 1
Apple Ipod ------ 125 ---------- 1

When I buy multiple quantities of the same item (regardless of the "buy price"), I just create a new row for each individual item with a listed quantity of 1. With me so far? The next spreadsheet I use, "Sales", lists the item name and the quantity that I sold. An example of my "Sales" spreadsheet is below:

Item ---------- Quantity Sold
Apple Ipod ---------- 2
Electric Fan --------- 2

What I am trying to do is remove the items that I have sold out of my "Current Inventory" spreadsheet, into a "Sold Inventory" spreadsheet. For example, according to the "Sales" spreadsheet I sold 2 Apple Ipods. I want to remove the first two rows that contain the item name "Apple Ipod" along with the buy price for each of those items. I am basically just trying to use a First In First Out inventory method, but it is tough (for me) to track with the multiple "buy prices."

Does anyone have ideas on how I can accomplish this?

Thank you!

Hi Sean,

Thank you for your response! Could you tell me how I could replicate that code, or what you did? Also, when I run the code, I don't see the buy price of each item in the sold inventory spreadsheet. Is there a way to add that?

Thanks so much!!

Don