How To Create Eorm Like Pos In Excel

In this example I use the Developer tool Tab and Index() function.
at the first we must enable Developer tool Tab by these step:
 -------------------------------------------------------------------------
The First Click on File => Option => Customize Ribbon => (In there main tab) Check the Developer And than OK.

Now I have the above image to show what we need to do That :

+ How to do in point 1, 2, 3, 4, 5 

Point 1 and 2 is in the same step : drip Cambobox from Insert tool box in developer tab And Right click on Cambobox and Than Format Control, Next in field : Array Input select in product list by $C$7:$C$10 => in field Cell Link fill by: $H$7
Point 3 : this step we use Index() function : =index($C$6:$D$6,$C$34,4)
Point 4 : Calculate amount = c7*L7
Point 5 : Calculate Total = sum(L7:L15)
--------------------------------------------------------------------------------------------------------------------------

Thank For Come To Learn On My Blog ... See You Soon On New Post.