Hello Everyone !
I would like to make a invoice / Customer statment, when i put the Customer Code. All the data (Amount) from different sheet Toll, Receivable and Fines should be fetched and placed in the invoice area. Data should be sorted date wise. it should calculate the rent for every month (30 days) starting from "Rent date" for each month seperately.
I really need to finish this. Please give your valueable input or suggestion to make it better or solution. Attached is the sample workbook.
Bookmarks