I am trying to construct a simpel spreadsheet for capturing cycle counts of inventory. The spreadsheet easily captures the scan of the location and item number via a handheld barcode reader. My issue is that I would like to then allow the user to scan the item barcodes on each box and have excel count those scans. Any ideas on how to format the On-Hand Count column so it counts the scan rather than returning the item number each time? Thank you!
Below is a simple example of the layout
<TBODY>
</TBODY>
Below is a simple example of the layout
Location | Item Number | On-Hand Count |
xx-xx-xx | abc123 | 15 |
<TBODY>
</TBODY>