Hi,

I am trying to write a program a macro that will help me accomplish a
find and add. Please forgive me if this is too complex of a post but
I am new at programming so I hope someone might be able to help me out

I have a column entitled color and it lists the colors of cars on
specific lots.

[Lot] [Color]
214 3ax Red
214 3ax Green
214 3yb Yellow
386 3ax Blue
386 3yb Gray
386 2xb Yellow

My problem is that the letters and numbers in front of the color may
change, but somewhere in the color column there will always be the
color name (i.e. Red).

I have a predetermined list of colors (there are many different kinds
of colors) and I am trying to write a macro that scans the color
column for each lot and if finds that a specific color keyword is
missing it will add a row to the end of the lot and add the missing
color name into it.

So if the macro went through all the records in lot 214 and saw that
the color gray was missing it would go to the end of that section and
add a row and put the word "gray" in the second column of the new row.

I know this is a little complex, but any assistance that any one could
offer would be highly appreciated.

Sincerely,
Rambo