Hello all,
I am working on a spreadsheet similar to the attached file everyday. The spreadsheet I worked with can create labels for the materials with a Record ID on it and once that materials were shipped, that label will return to me and the next step that I will do is to update the spreadsheet by filling the Date Shipped column on the corresponding Record ID.
This is a lot of searching and scrolling specially when the list is in hundreds just to find the Record ID.
With this, I think of a way to automate the process by using barcodes, so I did include a barcode of the Record ID of the corresponding labels, so that when the labels return back to me, I will just scan the barcode while on the spreadsheet, and there I have the Record ID in a click of a button. But I don't have enough skill in VBA and I'm asking your help to do the next process which is the VBA code in the command button. With the Record ID already on a particular cell by the aid of barcode scanner and manually input the date shipped on another cell and a command button to execute the process of searching and stamping the date on the corresponding column, I do believe that it is possible to create a simple VBA for that....It will be a great help for me. I thank everybody in reading this and I will appreciate very much for any help you can extend.
I am working on a spreadsheet similar to the attached file everyday. The spreadsheet I worked with can create labels for the materials with a Record ID on it and once that materials were shipped, that label will return to me and the next step that I will do is to update the spreadsheet by filling the Date Shipped column on the corresponding Record ID.
This is a lot of searching and scrolling specially when the list is in hundreds just to find the Record ID.
With this, I think of a way to automate the process by using barcodes, so I did include a barcode of the Record ID of the corresponding labels, so that when the labels return back to me, I will just scan the barcode while on the spreadsheet, and there I have the Record ID in a click of a button. But I don't have enough skill in VBA and I'm asking your help to do the next process which is the VBA code in the command button. With the Record ID already on a particular cell by the aid of barcode scanner and manually input the date shipped on another cell and a command button to execute the process of searching and stamping the date on the corresponding column, I do believe that it is possible to create a simple VBA for that....It will be a great help for me. I thank everybody in reading this and I will appreciate very much for any help you can extend.