I’m new in this forum, also using an arduino, but i can see the potential of it. And i’m getting really excited :-)
I would like to build a tool for my work, to improve our productivity. Basically, we need to put some items back to stock, and to do so we need to sort them. On each item is a barcode (to identify it), and each item has a specific location where it needs to go.
Currently, we do it « manually » : we scan an item with excel, it shows us the box number where it belongs, we find the box and we put it inside.
I would like to have the see the box where it belongs directly, without having to look for it all the time. My idea is to scan each item, and a light will switch on over the corresponding box where to put it. I would like to build it with excel/vba, as all data of items and boxes are in there, and then use an arduino to get the info from excel and switch on the correct light. I will need about 40-50 lights, to switch on one by one (never more than 1 at a time).
Do you know how i could do this ? I could see a lot of idea on the different forums, but didn’t manage to find the right one.
Thank you very much for your help,