Excel Spreadsheet for Print Orders

I need a spreadsheet designed for me to include the following columns and functions: * Photo ID - (which they get from a 3rd party app) * Print Size - Each cell should have a drop down menu (that should visibly be a drop down menu without being selected) that has multiple sizes to choose from - like 4x6, 5x7, 8x10 * Price - Each size will have a value, like a 4x6 will be $10 that when selected it will populate this cell with the price. * Quantity - When quantity is adjusted, it will multiple the value of the print size selected * Total - This will be the total amount of that row. I.E. someone enters a Photo ID, then chooses 4x6, the value is $10, then they enter in 15 in quantity, the total for that row will be $150 * The bottom of the spreadsheet needs a running total for how much everything is from all row totals combined.