Excel order form help - i really need help if possible

Hi everyone

Ive spent hours trying to get this right but it just isn’t working. Im no Excel wizz but I thought id have no issues getting to grips with it but …I NEED HELP PLEASE. Does someone fancy a challenge?

I need the order form to auto calculate total costs based on what the customer picks.
• I have a list of prices for batches/sandwich (same pricing) and Baguettes (cost more) fillings
• I have a list should the customer want extras (extra 40p)
• I have a list for the jacket potato fillings but these have no financial value assigned to them, this is just required to see what the customer wants.

I think the issue is the variables I have in the order form, but those variables are required.
I have provided 4 examples with the price manually typed in. I would like that price to auto populate saving the customer having to add this all up manually.

I hope someone can help me PRETTY PLEASE.

Thanks all,

Andy

do you want to fill in textboxes based on a dropdown selection? that's what it sounds like. I did NOT look at your file. however, if that's what you want to do, the solution depends on where the data that you want to autopopulate IS AT, and how it is layed out. but, one example to do this would be:

=> consider you have this data in cells A1 - A5, B1 - B5, and C1 - C5 on ""sheet1"":

PRODUCT, QUANTITY, PRICE PER UNIT

Please Login or Register  to view this content.

and you have a dropdown on your form called cmb that pulls from the first column (the fruit entries). and then you have 2 textboxes that you want to autopopulate the 2nd and 3rd columns (the quantity and price) into based on what the customer chooses from the fruit dropdown. the textboxes are called txt1 and txt2. the name of the form you are working on is frm.

=> the rowsource for the cmb would be:

Please Login or Register  to view this content.

and on the change event of the cmb you would write the code:

Please Login or Register  to view this content.