Dear Sir or Madam:

I am providing below the explanation of the problem I am trying to solve along with the data. Any help with the coding would greatly appreciated as I am new to to programming. I am using VB Net. Thanks!

Color Value
Green 2
Red 1
Purple 4
Blue 6
Yellow 3
Orange 5

Red,Purple,Green,Yellow 1+4+2+3

In columns "A" and 'B" I have the raw data as color and its values. In column "C" and any arbitrary row I want the user selected colors seperated by commas (except there should be no comma for the last item selected), and in column "D" in the adjoining cell the sum total of the values of the selected colors. How do we do this through Visual Basic code? Thanks!

Replies can also be emailed to me at Removed By Mod.