Hello everyone,
I am new to VBA and have become stuck, Can someone please help?
As you can see i can add or remove stock using in-out sheet but only if it matches cell to cell wothing vba,
Is there a way to match item selected and then add or remove stock quantity, ie: like a lookup>
Many Thanks
Hi, if you intended to upload a file, please try again. Don't forget the 'Start upload' button and wait until it's ready before you submit your reply.
Please see attached file
The code you've written (or copied or whatever) is a mess.
No logic whatsoever, the dropdown list in IN-OUT does not make sense
There's a long way to go if this a project you're taking seriously
Taking a look at the code you've got an overkill of unnecessary data
Searbox sheet, Data sheet and the Dynamic sheet is something I do not knwo why you even consirede it.
Try the attached file, just select the item in the IN-OUT, place the quanty and choose in or out and press the button
There is no check to see if the qty out is greater that the QTY in stock but that you can work out yourself
Don't know if you're still interested in the file but I limited the file to the minimal tables and extra's
I left the searchfilter sheet but it's not used here.
The OUT is limited to the max QTY in stock so if you have 425 in stock and want 500 out it will only accept 425 OUT
Have fun playing around with it. BTW I simplified the formulas in the IN-OUT sheet you were still using the pre 365 techniques while using XLOOKUP()
