There are two spreadsheets in this project. On one spreadsheet I have over
8000+ rows with several columns: one column contains a product number,
another contains colors available for the product, and several other columns
describing the product. On the second spreadsheet I have about 2000 rows with
the same information.

Problem is: I need to somehow ask Excel to look at the second spreadsheet,
taking each row at a time, move over to the first spreadsheet, check to see
if the product number exists and then check to see if the color in the second
spreadsheet exists in the first spreadsheet. If the product from the second
spreadsheet doesn't exist on the first, I need to tell Excel to add a row to
the first spreadsheet. If the product from the second spreadsheet does exist
on the first and the color does not exist, I need to tell Excel to add a
return in the color column and then add the color from the second spreadsheet
to the first. If the product from the second spreadsheet does exist on the
first and the color does exist, I need to tell Excel to copy the row to
another blank spreadsheet.

HELP!!