I am using excel to make a Bill/invoice/receipt file. All the financial data for a client on one file. I got majority of the kinks I worked out. I have one issue i cant seem to figure out. On the "Receipt" sheet i want to enter the info ( Payment date Payment Type and Amount paid) and have it appear on the "Bill" sheet. The Bill sheet will show previous payments. I would like it if the info that is entered on the Receipt sheet transfers to the Bill Sheet and have it fill in the empty slot. On the receipt sheet payment date is on cell B16 , Payment type in cell C16, and Amount paid in cellD16. I would like for these 3 cells to transfer to the Bill sheet. But if the row is occupied by a previous payment it just moves down to the next available row.
Example using the attachments: I have received a payment on 01/01/2015. I put it the Receipt sheet and it transferred to Bill sheet ( as shown). I get another payment from the same client on 1/09/2015. I enter it in the Receipt sheet and I want that data to transfer to the Bill sheet's row 18 (or next available row) in their respected columns. I want this to repeat every time i enter a payment into the receipt. I will delete the receipt data will be deleted after i print the receipt for the client; or if possible, the data be cleared anytime time i close the excel document with out losing the data that was transferred to the Bill sheet.
I understand i can just enter this data manually. It would only take an extra few seconds to do. Call it lazy but it makes it easier for any new hires or the other office employees here. If any one knows how to do any of this and can show me, it will be much appreciated.
Bookmarks