Sounds like a job for Data Validation
http://www.ozgrid.com/Excel/data-validation.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Peter" wrote in message
...
Hi,

I have list on names on my first sheet in A column, on sheet2 i have list
of
products with names. How can i create drop-down list for each name, so
that i
can select items from the list from second sheet, also drop-down list
should
remember maded selection for each name.

Is it possible?

Thank you in advance.

Peter