Need Help with making Inventory Sheet: Removing items and logging the date

So you already have code to add stuff to sheet1 and this code interfaces with a barcode scanner?
If so, where is this barcode scanner code.

You have a lot going on here and since I don't have a scanner to see what happens if I change something I'm going to play it safe.

If you click on the manage inventory button and choose to Add/Update records, as you know if something exists it brings up the description and gives you a quantity. I noticed you can change that quantity if you like. So if you change the quantity to something less than it already was and press the button will get a message telling you that you are subtracting whatever the difference is.

So if the amount was 500 and you change it to 400 you get a message box saying you are subtracting 100 and when you click update the quantity will change to 400 and on the second sheet you will get the information you asked for.

I will post the code with the changes I made highlighted, and the workbook so that you can test it out. Don't test it on your actual inventory until you have tested it on the attached file and are happy with it.

Please Login or Register  to view this content.

Not code that I wrote, but I would suggest that you might have changed the name of your sheet from "sheet1" to something else and that's why you are having a problem. Looking at the picture you posted I see that you have a sheet named "Inventory" and one named "Log", the code is referring to a sheet "sheet1" which doesn't exist.

Originally Posted by petg

Thank you so much ! It is doing exactly what I want, would I be able to add another feature such as when I add to the quantity it logs it in the second sheet as well ?

This is outside of your original request. You should start a new thread.

Thanks for the rep. points.

Please click the Thread Tools drop down box above your first post and choose solved.