I run a business that involves shipping many items a week and I want to start inputting customers tracking numbers using a barcode system.

All customers are assigned a unique number: Column A. The unique number is printed as a barcode on the shipping label.

We would like for the process to work in the following way, we scan customers unique number on the shipping label, it should find the customer's unique number in the excell file, move over to the cell to the right (Column B), we scan and it inputs the tracking number. So the 1st scan is to find the customer number and the second scan is to input the tracking number. Ultimately we would like this to be a 2 button press solution, click once on the scanner and it finds the code and the second press it inputs. Please let me know if its possible.

Your help is much appreciated.