Update inventory worksheet by adding/subtracting stock with the quantity.

So you want to add a quantity next to a number on the outgoing sheet and have that number subtracted from inventory?

Add a quantity next an incoming part number and have that number added to inventory?

If it can't find the part number in inventory then you want a message saying the part number can't be found?

This is what I will assume and will check back in a few minutes and see what your reply is.

Okay I just wrote regarding my assumption in post #2.

This code has to go in a specific place.

For the first code right click on the "Incoming" sheet tab and choose view code and paste the code in the white window.

For the second code right click on the "Outgoing" sheet tab and choose view code again and paste the code in the window.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The line in each code that says Application.Goto rngFound will take you to the part number on the inventory sheet. You can use this to show you that it's working correctly. You can remove that line if you want it's just there for testing purposes.

Yeah, that's what I did.

It works only if you enter the information in incoming/outgoing.sheet individually and press enter.

Well you have to push enter any time you enter a number, so what's the issue? How are you entering a chunk of numbers at a time? What's wrong with just having it update when you enter a number?

I need some way to tell the code which numbers to update.
Is there a date column with the date, or are you going to highlight the numbers that need to be updated, your example was very basic, I really don't want to go back and forth because something isn't the same as what's on your sheet etc.

If you are going to copy and paste a bunch of numbers onto those sheets the code has to know which are those in question.

If there's a date column with the current date when you push a button that would work or you would have to highlight the cells.

If the data you posted isn't an accurate representation of your actual data there may be issues so you might want to post a better workbook.

What would you specifically like to do if an item doesn't exist in inventory. Add it to the inventory if it's incoming, give you a message that the item doesn't exist if you are trying to remove it from inventory?