Drop-down list
 

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.

--
5328 L C

Drop-down list
 

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

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

"Liz C" wrote:

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.

--
5328 L C

Drop-down list
 

Thanks a lot Eduardo. It is a great site.
--
5328 L C


"Eduardo" wrote:

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

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

"Liz C" wrote:

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.

--
5328 L C