Hi Veronica,

May be a dependant data validation list is the answer

http://www.contextures.com/xlDataVal02.html