Hello all, i work in a wholesaler and i am trying to find a solution in keeping track of where stock is by what location and a description of what is on each pallet and the quantity, my knowledge of excel is pretty basic but i was wondering if anyone would know if my proposal to use excel for this purpose would work, i have created a basic idea of what it would look like, Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting
My idea is to scan the barcode of the item on the pallet (probably by using a bluetooth barcode scanner linked up to a tablet displaying the spreadsheet) into the 'scanned items' and then somehow to bring up the information from the (mini) database on the right to display the rest of the details of that scanned item, then the user would have to input the quantity and the best before date, is this possible to do? i know it will take a while to input all of the items we stock as there are over 25,000 but once it is set up in the 'database' i think it would be worth while as the person who is moving stock either putting it in a location or removing it could just scroll to the location on the spreadsheet, scan the item and it would input all of the data to that location, then if someone was looking for a specific product we could just check the spreadsheet to see where that item was, as at the moment we would physically walk the whole warehouse looking at all the pallets until we find the item. this also brings me to my next question, is it possible to search for words (in this case a product name) within a spreadsheet, e.g. looking at my mock up spreadsheet if i was looking for CL Flour, could i input that somewhere into the spreadsheet and it would automatically find that then tell me where the location is, as we have over 200 rack locations, thank you for reading and i look forward to any replies! Steve Cannell
My idea is to scan the barcode of the item on the pallet (probably by using a bluetooth barcode scanner linked up to a tablet displaying the spreadsheet) into the 'scanned items' and then somehow to bring up the information from the (mini) database on the right to display the rest of the details of that scanned item, then the user would have to input the quantity and the best before date, is this possible to do? i know it will take a while to input all of the items we stock as there are over 25,000 but once it is set up in the 'database' i think it would be worth while as the person who is moving stock either putting it in a location or removing it could just scroll to the location on the spreadsheet, scan the item and it would input all of the data to that location, then if someone was looking for a specific product we could just check the spreadsheet to see where that item was, as at the moment we would physically walk the whole warehouse looking at all the pallets until we find the item. this also brings me to my next question, is it possible to search for words (in this case a product name) within a spreadsheet, e.g. looking at my mock up spreadsheet if i was looking for CL Flour, could i input that somewhere into the spreadsheet and it would automatically find that then tell me where the location is, as we have over 200 rack locations, thank you for reading and i look forward to any replies! Steve Cannell
