VBA Coding and Functions

[Vishal2204]

Hello,

I have a Excel File in which I have given some Excel functions to calculate the figures/amount. But I wanted to do all these this in a Form. I have created a form but I'm illiterate about <acronym title="visual basic for applications">VBA</acronym> Coding. can someone please help me.

1. Form should find empty row and add new bill.
2. Form Automatically get next Bill No. (if 2 bills are done it should take Bill No. 3)
3. One bill has multiple Products and Bill Amount should sum for all products for the same bill (I used SUMIF in Excel)
4. It should search bill, edit bill, add, or print bill.
5. Auto calculate totals.

Data:

Date	Bill No.	Party Name	Product	Delivery Qty	Return Qty	Net Delivery	MRP Rate	Retailer Rate	MRP Total	Retailer Total	25% Less	Bill Amount	Received Amount	Balance
01-Apr-14	204	ABC	Note Book	256	90	166	10.00	8.00	1660.00	1328.00	1245.00	2260.00	2200.00	60.00
01-Apr-14	204	ABC	Ink	60	24	36	15.00	12.00	540.00	432.00	405.00
01-Apr-14	204	ABC	Pen	20	17	03	20.00	16.00	60.00	48.00	45.00
02-Apr-14	205	XYZ	Note Book	200	60	140	10.00	8.00	1400.00	1120.00	1050.00	1764.00	1700.00	64.00
02-Apr-14	205	XYZ	Ink	100	38	62	12.00	10.00	744.00	620.00	558.00
02-Apr-14	205	XYZ	Pen	50	47	03	10.00	8.00	30.00	24.00	22.50

<colgroup><col><col><col><col><col span="11"></colgroup><tbody>
</tbody>

Please Help