OK.. Sorry in advance, I'm very new to VB (I understand basic concepts) but I need a little help here. Long story short, I'm migrating some data from one excel file to another, but there are some data structure changes. I know it seems as if I'm using Excel as a database, but right now it's just an easy medium to manipulate data in until it gets imported into the real database. My only problem is that I need to automate specific parts. Right now I'm using VBA within Excel to basically build some simple macros to move data around, but I've run into a situation I'm not sure how to code.

Scenario is this: source table has an unspecified number of rows, one column has name of a person, another column has an item ID # that they are associated with.

Destination table needs to have the item ID # in one column, but in place of the name, the destination table needs to have a user ID.

I have this third reference table that has the names tied to user ID's.

So basically, I need to go through each record in the source table, copy it over to the destination, then look up the name and replace it with the appropriate user ID from the reference table.. I'm think it's a pretty simple thing to do, and I've seen examples for SQL, but I can't really get my head around how to do it in VBA right now.

Any help?