I have a workbook used for sales. A userform is used to enter sales on the , "sales and balances" tab. Now, am planning to incorporate a receipt feature for printing receipts where the user needs to select the item name from a drop down list, enter the quantity to be sold and enter a discount (if necessary).
My challenge is transferring the items from the receipt to the sales page. In other words, I want the receipt form to perform the same function as the userform in the " sales and balances" tab.
How the userform works
The user selects the item from a combo box, enters the quantity, date( auto-populated) and submits it. The inputs from this user form is not directly recorded on the "sales and balances " sheet, instead it is recorded on the " user" sheet. The "sales and balances" tab is then referenced to this "user" tab.


what I want from the receipt form
The receipt form has 4 inputs I want recorded which are the item names,discount, quantity and date.I would want the input ( item name, quantity and date) to be also recorded in the " user" tab while the "discount" input should go directly to the " sales and balances" sheet in the corresponding row.


Hope you understood. Am here to answer any question.


attached is the workbook.
Thank you.


attachment here http://www.4shared.com/office/OE9uTr...nager__1_.html