Macro that Matches Scanned Data

[singinwes]

I have a project that takes data scanned in and matches it together as a check in/check out type system. In the example attachment, I need the scanned data in sheet 2 to populate the respective rows and columns in sheet 1. Basically, when a Tray ID is scanned, I need it to either populate row 3 or 6, depending on whether that tray is checked out or not. For example, when a tray ID has been scanned an odd number of times, I need it to start a new row, as it's being checked out, etc. I'm trying to find a macro that either:

• Takes the scanned in data on Sheet 2, puts it in its place and matches it in sheet 1.
• Places the scanned data where it belongs in Sheet 1 in the first place, matching Tray IDs as it's entered.

I sincerely appreciate any insight you can provide for me here.

[dangelor]

Possibly...

Please Login or Register  to view this content.

...placed in sheet2 code module.

[singinwes]

Well I just realized I said row 3 and 6 instead of column 3 and 6. I'm using R1C1 because my employer requires it. Sorry for the confusion. This looks promising, but I'm not sure what I need to update to resolve my mistake.

[dangelor]

See the attached file..

[singinwes]

Oh nice, you saw through my initial mistake! This is great and is so close to what I need. It's filling in column 6 when it matches a pre-filled column 3, but it isn't doing the initial "scan in." For example, if sheet 1 is empty and I enter a 4 on sheet 2, I need it to fill out out column 3 on sheet 1 with that unmatched 4 on the next "empty" row. Does that make sense? This is extremely helpful, thank you for your help so far!

[dangelor]

Try this...

Please Login or Register  to view this content.

[singinwes]

That's absolutely perfect, thank you so much for your help!

[dangelor]

You're welcome!