Populating Values In One Table With Values From Another Using VBA

S

Sheldon Potolsky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top