Hi

Does anyone have any experience of using Excel for stock taking/counting?

I'd like to speed up the process of counting stock, I currently print out excel files, count the products and then manually update.

I'd like to be able to automate the system to a certain degree, using the product's barcode to identify it, then enter the count, then be able to see which counts differ, then manually update or investigate any discrepancies. Ideally!

Any help, tips or pointer would be appreciated.

Thanks
James