clindemeier
New Member
- Joined
- Sep 15, 2003
- Messages
- 8
I am looking for help to create VBA script for an order entry form:
We organize a dinner event at our kid’s school.
People will place their reservations upfront, so we can better estimate the volume and the type of menu’s that will have to be prepared.
Our guests will also asked to pay the ordered menu’s upfront.
During the dinner event, we plan to use a spreadsheet at the counter.
We’ll select the customer’s name from a drop down, get the customers “reservation overview” from another worksheet via VLOOKUP.
On the cover worksheet we'll then add the incremental orders from the event itself (mainly beverages). The spreadsheet then calculates the amount to be paid.
So far so good. We have developed this spreadsheet….but the total price calculation is not stored anywhere.
For the post-calculation of our whole event, it would be great if we could add the INCEMENTAL ORDER details to the client’s row on the 2nd worksheet (Customers).
After the event, we could then make accurate reports as of how many beverages/menus have been paid in total.
I know we have to use a button that triggers a VBA script, but I have no experience inVBA.
Can anybody help me out?
Teh current version of my spreadsheet is attached.
Thanks,
We organize a dinner event at our kid’s school.
People will place their reservations upfront, so we can better estimate the volume and the type of menu’s that will have to be prepared.
Our guests will also asked to pay the ordered menu’s upfront.
During the dinner event, we plan to use a spreadsheet at the counter.
We’ll select the customer’s name from a drop down, get the customers “reservation overview” from another worksheet via VLOOKUP.
On the cover worksheet we'll then add the incremental orders from the event itself (mainly beverages). The spreadsheet then calculates the amount to be paid.
So far so good. We have developed this spreadsheet….but the total price calculation is not stored anywhere.
For the post-calculation of our whole event, it would be great if we could add the INCEMENTAL ORDER details to the client’s row on the 2nd worksheet (Customers).
After the event, we could then make accurate reports as of how many beverages/menus have been paid in total.
I know we have to use a button that triggers a VBA script, but I have no experience inVBA.
Can anybody help me out?
Teh current version of my spreadsheet is attached.
Thanks,
