Hi, my job require me to check assets using scanner and this is the excel format my company given me. But at this moment, when I scanned, I had to first search for the correct barcode and then I scanned it at that column. Then the checked Column will turn Yes/Green. As my job require me to walk around with my laptop I had difficulties in searching the data while holding my laptop on my hand specially for a long period of time if I am conducting a Annual Stocktaking of the 2000 Assets within 3 days.
Therefore, I trying to see if I can improve on the scanning process, and if there is any ways or methods that allow excel to auto search and input the barcode to the correct cells on a scan here box I created on top of the spreadsheet, but try many ways, but unable to do it. And also hope that at the end of the check also help to caculate the total qty of the Yes and No checked by Asset Type, so that I can input them into my main report.
Hope that someone, can help me on this. Thanks.