jatkins901
New Member
- Joined
- Oct 28, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello all,
I'm very new to excel. I am creating inventory work sheet using barcode scanner where every time you scan, it will only match first 10 characters from part and deduct one from total quantity. Every time a part is scanned, it needs to identify right part under 'PART NUMBER' and auto deduct from 'QTY SHIP ON'. And last, how can I implement a 'error massage' on screen if barcode dose not match any of 'PART NUMBER'?
Thank you.
I'm very new to excel. I am creating inventory work sheet using barcode scanner where every time you scan, it will only match first 10 characters from part and deduct one from total quantity. Every time a part is scanned, it needs to identify right part under 'PART NUMBER' and auto deduct from 'QTY SHIP ON'. And last, how can I implement a 'error massage' on screen if barcode dose not match any of 'PART NUMBER'?
Thank you.