Hi,

I have an old inventory program on my business and the reports that generate are limited, I'm trying to re-order the items i've sell since january 2017 but I don't want to order stuff that I already have, but the program doesn't make that kind of stuff, so the only thing I can generate is my current inventory and the items I've sell since january separetly, and I was wondering If I could do in Excel a sheet that takes both reports and organize it on their rightful items and make two columns one that says selled, and other current inventory so I can see what how much I should order of an Item. This is difficult AF for me, I tried and tried and nothing, hope for some help

right now I'm ordering items looking at them one by one, and that way takes a lot of time for me
if you need kind of an example of what I'm talking about just tell me

sorry for my english!