Choosing a list item

rntservices Posts 1 Registration date Monday January 9, 2017 Status Member Last seen January 9, 2017 - Jan 9, 2017 at 04:29 PM
 Blocked Profile - Jan 10, 2017 at 05:17 PM
I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet
Qty Unit Price Price YT004-Oscar Terrones, cells below name will be chosen,
0.00 $13.00 $- need to have unit price become filled
0.00 $15.00 $- in once a name is chosen.
0.00 $71.00 $-
0.00 $71.00 $-
0.00 $71.00 $-
0.00 $71.00 $-
I realize I will have to repeat alot of this language/code to repeat the same results over and over again. I am learning this level but am very able to follow

Thank you,


1 response

Blocked Profile
Jan 10, 2017 at 05:17 PM
OK, well a drop down list will not only display the list, but it will place the final selections into what ever cell you want.

Are you having an issue producing a drop down? what version are you using?