marty1975

10-12-2015, 09:14 AM

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.

For example:

Rack1

A1 08-15-278-0019

A2 08-15-278-0020

A3 08-15-278-0021

A4 08-15-278-0022

...

A12 08-15-278-0124

and so on...

Rack2

A1 08-15-278-0101

A2 08-15-278-0079

A3 08-15-278-0156

A4 08-15-278-0025

...

A12 08-15-278-0235

and so on...

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.

Attached is what I have so far.

Thanks for your help.

Marty

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.

For example:

Rack1

A1 08-15-278-0019

A2 08-15-278-0020

A3 08-15-278-0021

A4 08-15-278-0022

...

A12 08-15-278-0124

and so on...

Rack2

A1 08-15-278-0101

A2 08-15-278-0079

A3 08-15-278-0156

A4 08-15-278-0025

...

A12 08-15-278-0235

and so on...

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.

Attached is what I have so far.

Thanks for your help.

Marty