A Way to edit an inventory list through a macro in a different workbook?

Hello! Right now I have an inventory list that has a macro in it where you can manually add parts onto a reserve so that other people will not use them.
Basically you just type in the quantity and the part number and it will look up the part number within the inventory and add whatever quantity was specified to the 'On Reserve' cell in that row.

What I am trying to do is change that process so it happens automatically. I have a work order template with a button "Book PO". When that button is clicked, I would like the macro to find the list of part numbers and their quantities on the work order and then open up the inventory list and find each of the part numbers and then change their On Reserve amount.

This is what I have at the moment

Please Login or Register  to view this content.

When I run that it says "type mismatch" referring to the addition symbol in

Please Login or Register  to view this content.

Any help would be appreciated

This post is cross referenced at: https://www.mrexcel.com/forum/excel-...-workbook.html

I tried adding an If statement to see if it would fix the mismatch error and it did not, but here is the second attempt:

Please Login or Register  to view this content.

Please upload a desensitized sample of inventory book(containing maximum 20 records) and the fron end book. Put some desired results that will be fetched from the Inventory book.

Still not clear how did you map the both

What I am showing with the colors is that the Part Number in the Work Order can be found somewhere in the list in the Database. I highlighted with color to show the three that the macro should find in the list. It should then take the quantity in the "Qty." column of the Work Order and add that number to the quantity of what is "On Reserve" in the Database. In addition to that the quantity in the "Qty." column should be added to the "2018 Sales" column in the Database in the row of its Part Number.

So since the part number 001234567891 has 2 parts already 'On Reserve', the 2 in the "On Reserve" column should be replaced with 22 (because the quantity in the order form is 20). The "2018 Sales" column should then read 45 because of the 20 new parts and the 25 parts already sold.

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

find each of the part numbers and then change their On Reserve amount.

It seems it is not only the amount you change but also the "Delivered" added to "2018 Sales"
Is it ??

See next code and comment

Please Login or Register  to view this content.

Excellent, you are now the owner of the code ...!
Is the story done ??? If yes close the thread .

First loop (For) is ending before the second one

Please Login or Register  to view this content.

you should have

Please Login or Register  to view this content.