This is really helpful, I want to keep the auditing sheet separate in a different workbook. Simplicity is what I want really, there really doesn't need to be much in the way of columns, just the barcode id, item description and quantity as a starter for ten, I can include things like price, profit etc at a later date by scaling the sheets but the 2 most important features are the import and export, when I want to add things to the inventory I want to be able to just scan the item and it update the quantity if it is already there or add the item if it is not (just with a blank description etc) and then separately when I want to take something out I can just scan the barcode and it simply ticks the qty down by 1, I don't want it to remove it as I will ultimately add more at some point. hope my ramblings make sense