First of all apologize to all as I am a newbie and have only entry level experience in excel.
Attached is the sample file,
- I want to enter the customer name in the "receipt voucher" sheet and want to populate the table with the pending invoices details.
- I will enter the amount paid by the customer in the table displayed.
- After entering the data in the table I want to update the entered data to be updated in the "invoice register" and " "cash receipt register" sheets.
Bookmarks