I have a drop down box that I need my selection to populate the rows of data on the order sheet from the master sheet... For Example
Drop Down Box includes Apples, Oranges, Pecans, Grapes
The master list has hundreds of products but when I enter a order number only certain products populate into the dropdown box...
So in the master sheet column A=Order Number, B=Product, C=Price, D=Quantity, E=Location
I need a complicated vlookup/hlookup that I cannot figure out or a macro that will input the data from master list into the order sheet...
I select Apples on the order sheet, then in the Price column on the order sheet say A33 I need the price of the Apples from Order number 989 only to populate there. in B33 I need Quantity, and C33 I need Location and so on...
Can someone please help me figure this out I have been trying to get this working for about 3 days with no progress!!!
TIA!!
Drop Down Box includes Apples, Oranges, Pecans, Grapes
The master list has hundreds of products but when I enter a order number only certain products populate into the dropdown box...
So in the master sheet column A=Order Number, B=Product, C=Price, D=Quantity, E=Location
I need a complicated vlookup/hlookup that I cannot figure out or a macro that will input the data from master list into the order sheet...
I select Apples on the order sheet, then in the Price column on the order sheet say A33 I need the price of the Apples from Order number 989 only to populate there. in B33 I need Quantity, and C33 I need Location and so on...
Can someone please help me figure this out I have been trying to get this working for about 3 days with no progress!!!
TIA!!