Since I haven't seen any ideas posted for how to do this
in Excel, I have a second idea.

I have code for doing this in Access. I've only used code
in access. So my question is, with a little modification,
is it possible to convert my Access code to Excel?

My Access code is
Me.Products.RowSource = "Select ProductName FROM" &_
"Products WHERE CategoryID = "Me.Categories &_
"ORDER BY ProductName"
Me.Products = Me. Products.ItemData(0)

thanks for the help.