Please help..How to autofill a price sheet.

[imenacedk]

This might be something simple to you experts.

I'm updating a order sheet for products and most of these stores pick and purchase a package A or package B. As I try to explain visually below...I have a list of products going down and I would like to have 1 Drop down menu named "Pick order" In that drop menu there would be a "Package A", "Package B", " Blank". When anyone chooses the package the preset quanitity of the products will automatiicaly fill going down. Is this possible? And if so please newbie talk me, thanks!


A B C D E
Inventory ID Product Name Product Description Price Pick Order

 

[venkat1926]

I am giving you a trivial data a1 to a5 in sheet2
the data and quanity are like this

Sheet2

*	A	B
product	quantity
a
s
d
f

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]4[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

suppose you are likely to fill the data iln sheet1 A2 to A20 with headings
product quantiy
in A1 and B2

in a module copy this macro

Sub range_validation()
With Worksheets("sheet2")
Range("A2:A5").Name = "rv"
End With
Worksheets("sheet1").Activate
With Range("A2:a20").Validation
'in sheet1 data likely to be a1 to a20.moify if necessary
.Delete
.Add Type:=xlValidateList, Formula1:="=sheet2!A2:A5"
 .ErrorTitle = "not a valid entry"
 .ShowError = True
 End With
End Sub

the cells A2 to A20 iun sheet1 will have validation.

now in B2 in sheet1 type this formula

=VLOOKUP(A2,Sheet2!$A$2:$B$5,2,0)

and copy this down upto B20
you will have #N/A in all these cells do not waorry.
now select A1 in sheet 1 you will have a small arrow at the bottom right of the cell A1. click that arrow you will get a list
a
s
d
f

now click any one of them for e.g. a
thant automaticallly B1 will beco;me 1
simiraly do same operation on A2. B2 will change

I hope the solution is clear.
copy sample data given in your file.
follow step by step you will understand