Hi
I Would like to thanks all you guys, first Because i have made this file/Code From your Amazing Help, i have this Workbook Coded to find the Value Entered by barcode scanner and add/deduct from the "E" Col. but i have an Extra Feature if you could help me With it.
1. I need a Message Appears Once counted Inventory Exceeds the Approved Quantity.
2. Once Reached the Approved Qty it cannot Add More Qty, but it can be Deducted.
Explanation:
The Person will Scan the Barcode in the Cell "B1", it Will search within the Range A,B,C until the End of Entries, and then Increase the Number in "E" (Count), What i need is Reject any Value Greater than the Approved Qty "F", Once scanned and the Value will be Over Approved Qty then Reject the Entry and Display Message to the User.
And if that Possible you could Comment the Steps for my Reference
I don't know why the Attachment System not working with me, but maybe the Screenshot will help somehow, i will try to attach the file once reached home maybe from Office PC is now allowing me to attach or anythingPlease Login or Register to view this content.
Capture.PNG
Thanks and Regards
M Habib
Bookmarks