swagat
10-10-2011, 11:10 PM
My workbook has two sheets by the name bill and customers.
The bill worksheet generates a bill for a customer name in H2(present in the customer worksheet in column A ) with the help of a drop down list.
Now I added a command button to my bill worksheet which when clicked should add the total amount present in cell F2 ,to my customers worksheet for the particular customer's previous credit amount in column B.
For example if bill is generated for Harry then pressing the command button adds the bill amount to harry's previous credit in my customer sheet.
The bill worksheet generates a bill for a customer name in H2(present in the customer worksheet in column A ) with the help of a drop down list.
Now I added a command button to my bill worksheet which when clicked should add the total amount present in cell F2 ,to my customers worksheet for the particular customer's previous credit amount in column B.
For example if bill is generated for Harry then pressing the command button adds the bill amount to harry's previous credit in my customer sheet.