| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not ALL values are populating to Combobox for some reason. Why ? | Excel Programming | |||
| Populating Document property values using macro | Excel Programming | |||
| populating DropDown with Values Of a Column in another Sheet. | Excel Discussion (Misc queries) | |||
| Populating a table based on values in another table | Excel Worksheet Functions | |||
| Populating a listbox with values from a sheet. | Excel Programming | |||
Threaded Mode
