I need a VBA form to be created in excel with can have a Vlookup function. I need 3 fields:
1. UPC: UPC to be scanned
2. Part Number: (auto populated when UPC is scanned)
3. Item description: (auto populated when UPC is scanned, the item description can be quite long so I would need a cell that would wrap the text into one cell)
The function would serve as an UCP verifier as I scan a UPC the part number and item description would populate. I would like to password protect if I need to enter new UPC's, part numbers, and item descriptions that are not listed.