I have no clue if this is possible or not, but here is what I am trying to do. I want to have a spreadsheet of product that has been scanned in using a bar code scanner. This will be in A1. I then want B1 to auto-generate the product name [using a table on another sheet?]. In C1 a timestamp will be recorded that the box was 'checked in' D1 will record the time the box is 'checked out' I also need a way to record who checks out said box, be it by inserting a name, highlighting the row a certain color etc. There will be multiple entries of the same product but I need them to each be in their own row, so that each individual box is its own row.
Is this possible at all?!? I have noooo clue how to write a macro but I do know they rock!! Can anyone help?! Thanks!
Is this possible at all?!? I have noooo clue how to write a macro but I do know they rock!! Can anyone help?! Thanks!