Warehouse Invoice Picking Stats -- 2
Budget: $30 – $250 USD
Good day,
I work in a warehouse and would like to track the performance of the invoice pickers. I want each picker on a shared excel (Teams/Office 365) to go to their name in a column and next to it in the next cell scan as many invoice numbers(Barcodes). Their names, timestamp and Invoice number must appear on the next sheet in columns. As they scan a barcode, it needs to "cut to the 2nd sheet and they need to be able to continue to scan as many invoice as they have to pick. This needs to be done/written in Office Scripts as it is the online version of excel. Almost like google script used for google sheets.
I work in a warehouse and would like to track the performance of the invoice pickers. I want each picker on a shared excel (Teams/Office 365) to go to their name in a column and next to it in the next cell scan as many invoice numbers(Barcodes). Their names, timestamp and Invoice number must appear on the next sheet in columns. As they scan a barcode, it needs to "cut to the 2nd sheet and they need to be able to continue to scan as many invoice as they have to pick. This needs to be done/written in Office Scripts as it is the online version of excel. Almost like google script used for google sheets.