K
Kevin S - 34210
I have a table of data and have created a drop down list based on the first
column. I would like to be able to choose an item from the list and then have
the additional info I choose fill the next two columns. Is this possible?
Here is a sample:
Product Spec1 Spec2 Spec3 Price
A 0.5 6 RED $2.00
B 0.5 4 BLUE $4.00
C 0.6 8 GREEN $6.00
D 0.7 3 BLACK $8.00
When I choose Product A from the drop down on the "Invoice" worksheet I
created, I want the Spec1 and Price to fill the next two columns...
Is this even remotely possible?
Thank you in advance for your time and effort in this matter.
Kevin
column. I would like to be able to choose an item from the list and then have
the additional info I choose fill the next two columns. Is this possible?
Here is a sample:
Product Spec1 Spec2 Spec3 Price
A 0.5 6 RED $2.00
B 0.5 4 BLUE $4.00
C 0.6 8 GREEN $6.00
D 0.7 3 BLACK $8.00
When I choose Product A from the drop down on the "Invoice" worksheet I
created, I want the Spec1 and Price to fill the next two columns...
Is this even remotely possible?
Thank you in advance for your time and effort in this matter.
Kevin