Your description is not very clear, so it would help if you attached a sample Excel workbook to explain your requirements more fully - see the yellow banner at the top of the screen for details of how to do this.

A Data Validation drop-down might give you what you want.

Hope this helps.

Pete