Say i have 3 columns of table labelled A, B, and C which serves as a barcode scanner to scan the tools that are being used for maintenance work daily.
I have a lot of reference from different table to look up the scanned item's detail for column B and C.
1. 6 technicians use this to track their respective team's work for that day.
2. However, the scanned items have missing information in column B or C.
3. It doesn't happen regularly but I can see some sparse in the sheet, as if its like a bug.
4. I have to manually key in the data that I know of myself. But this can be a bit tedious and defeat the purpose of building this function.
5. Can anyone help me with this?
LinkedIn
Twitter
