C
chief
i have a drop-down list set up in cell C19 where a user can choose fro
product code #'s ranging from "1-0001" onward. I would like to set u
a code that will enable the user to:
1.pull down drop list and select a code # (this i have)
2.once that # is selected, the corresponding product description wil
be placed in E19.
3.further more, the corresponding # or description will then b
recognized and will automatically input the corresponding Price ($) i
I19.
It is in hopes of saving the user time from having to type in th
product, then the price etc.
Just a note, i have validated my drop down code list (which sits i
cell C19) from column N. I also have the corresponding descriptions i
column O. I don't know if this helps?
I tried If range("C19").value = "1-0001" Then
range("E19").value = nails
End if
but it won't do anything once you choose that 1-0001 code #?
thank
product code #'s ranging from "1-0001" onward. I would like to set u
a code that will enable the user to:
1.pull down drop list and select a code # (this i have)
2.once that # is selected, the corresponding product description wil
be placed in E19.
3.further more, the corresponding # or description will then b
recognized and will automatically input the corresponding Price ($) i
I19.
It is in hopes of saving the user time from having to type in th
product, then the price etc.
Just a note, i have validated my drop down code list (which sits i
cell C19) from column N. I also have the corresponding descriptions i
column O. I don't know if this helps?
I tried If range("C19").value = "1-0001" Then
range("E19").value = nails
End if
but it won't do anything once you choose that 1-0001 code #?
thank