Populating Values In One Table With Values From Another Using VBA
 

If Table 1 has 2 columns with the following values:
Color ColorCode
red 1
blue 2
green 3

Now I also have a Table 2 with the same two columns. The ColorCode
field in Table2 has values filled in but Table2 doesn't have the
corresponding Color column filled in. Can I use VBA to fill
(populate) the Color field in Table2? Easy to do in Access, probably
the same with Excel VBA but I'm not sure how to do this. The VBA code
would need to run from within another macro. Any suggestions would be
appreciated.

Thanks, Sheldon Potolsky