Drop-down list

[Liz C]

I am trying to create a cost sheet for a cake, for example. It will contain
a list of ingredients, unit measure and the unit costs. I would like to be
able to click on the list of ingredients and the correct unit cost would be
called up. I am also wondering if it would be possible to create a list of
different cakes where the required ingredients would be called up
automatically.

Please kindly help me if anyone knows how. Thanks.

 

[Eduardo]

Hi Liz,
Here is a link to Debra webpage there you will find all your answers

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

 

[Liz C]

Thanks a lot Eduardo. It is a great site.