Auto Populate Order Form, based on qty's filled in Price list - Query

Hello there helper!

I have a small problem that i would like resolved.

I have a Pricelist sheet with columns - Code, Description & Price & Order Qty on sheet 1, and an order sheet on Sheet 2. if I enter a qty into the Order Qty column on sheet one,I need the Orderform (Sheet 2) to auto populate the items into the Orderform, preferably in the order that they appear in the Pricelist.

i would prefer not to use a Macro, as this will be document will be past onto others who often cant run macros. Is there a function that can resolve this issue for me.

Look forward to someone brilliant inspiration here. Thank you in advance

Please fill the expected result in Order Form sheet and show it to us for getting better understanding of your exact requirement

Welcome to the Forum.

Try these Array Formulas. Since these are array formulas so you need to confirm them with Ctrl+Shift+Enter instead of just Enter.

In A4

Please Login or Register  to view this content.

and copy down.

In B4

Please Login or Register  to view this content.

and then copy across and down.

I think for Net Price column, you need to calculate the Net Price as per the Qty and price (Qty*Price) on Sheet2.

Is this what you are trying to achieve?

You're welcome. Thanks for the feedback.
You may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.