Hello,
I am hoping I will find my answers here as combing the internet has not gotten me to the answers I need.
I currently have a spreadsheet with all my products and quantities, and I am updating manually each day which is a pain. My products have sku numbers in this excel sheet and i am wondering if it is possible with a bar code scanner to scan my barcode, have Excel find the sku and deduct the quanity from the cell. The same would go for inventory received. I hope I have explained what I would like, It seems simple enough but I am unaware as how to do it.
Thanks for all the help.
I am hoping I will find my answers here as combing the internet has not gotten me to the answers I need.
I currently have a spreadsheet with all my products and quantities, and I am updating manually each day which is a pain. My products have sku numbers in this excel sheet and i am wondering if it is possible with a bar code scanner to scan my barcode, have Excel find the sku and deduct the quanity from the cell. The same would go for inventory received. I hope I have explained what I would like, It seems simple enough but I am unaware as how to do it.
Thanks for all the help.
