질문하기

Ynatar's profile - activity

2015-05-12 12:52:35 +0200 받은 배지  유명한 질문 (source)
2015-05-12 12:52:35 +0200 받은 배지  주목할 만한 질문 (source)
2015-04-04 18:09:44 +0200 받은 배지  정리의 달인
2014-01-26 23:26:09 +0200 받은 배지  학자 (source)
2014-01-26 14:16:25 +0200 받은 배지  인기있는 질문 (source)
2014-01-25 23:50:52 +0200 받은 배지  편집자 (source)
2014-01-25 22:28:22 +0200 질문하였습니다 Is it possible that a drop-down could fill subsequent cells of the rows?

I would like to know if it's possible that when you choose from a drop-down list, other cells can be filled also. I'm trying to simplify cake cost calculation. I have a sheet with Product Description, Quantity and Price. In the other sheet I want to calculate for each cake.

What I would like to happen is as shown in image below: For example when I choose from the drop down list "Farinha", it autofills in the other sheet under "Valor" 0,00083€

image description