Steve,
Thank you so much for your reply. I understand DataValidation but that was
about all I understood from the reply.
Every item number that would be entered in Column A would have to have it's
own DataValidation list that would need to show in Column C. This is because
every item number has a different list of colors to choose from. Would I then
create this on another sheet and create an HLOOKUP? I'm so confused.
I'm feeling stupid but could you please try another way to explain the
answer to me.
Thank you for you time and patience.

--
-H


"STEVE BELL" wrote:

Put this code in the sheet module for that sheet

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 1 Then
' code to add a DataValidation list to column C,
' or code to change the DataValidation list in column C
End If
Application.EnableEvents = True
End Sub

Record and modify a macro to add or modify a datavalidation
and add this code to the above.

Remember to have lists created for color variations.
Or you can build extensive code to create those lists through code.

If you haven't worked with DataValidation - you'll find it under the Data
menu.

Write back if you need more help.

--
steveB

Remove "AYN" from email to respond
"H" wrote in message
...
Column A- Is an Item number that you enter manually
Column B - has an H lookup formula that refers to the number entered in
column A
(Column A is an item number and when entered in Column B the items
description comes up)
I would like column C to have a drop down menu that only has the color
choices that are available for that item.

I'm stuck on column C. Can you do an HLOOKUP formula refering to another
cell that contains an HLOOKUP formula?

Any help would be appreciated.
Thank you
--
-H