Hi, all. I am a novice at VBA but I am trying to create my own little excel spreadsheet for work and I could use some help.
This spreadsheet would keep track of the daily lab specimens in four racks. Each day of the week has four racks that sit in our fridge. For example, each rack would have, A1-12, B1-12, C1-12, D1-12, and, E1-12.
I would scan the barcode into the table and the barcode would be assigned to 'A1'. The programming would tell me where to put the next specimen. In this case, the next spot would be 'A2' if it is not already taken.
My question is, how do I assign the barcode number that I scan in to the already assigned cell number? For example, in Rack1, the barcode 08-15-278-0019 would be assigned to A1.
The reason why I want it this way is that the staff should be able to search the table at a later time and find that particular barcode 08-15-278-0019 is in A1.
Reply With Quote