Mukund Vyas
Member
Hello
i have created a xlsm file for making invoice bill. which includes sr. no. party name, date, amount, particulars, vat and total amount.
i want to make a new sheet which includes... a list of all customers and their details like sr. no of bill, date and amount. and i want to add payment date and due payment list. in due sheet.
i have two sheets for making bills, call charges and tax invoice, from that two sheets i want to make a new sheet for list of customers with amount details.
i am attaching the file here to understand easily
Please provide help for which formula to use and how to use.
thanks
Mukund Vyas
i have created a xlsm file for making invoice bill. which includes sr. no. party name, date, amount, particulars, vat and total amount.
i want to make a new sheet which includes... a list of all customers and their details like sr. no of bill, date and amount. and i want to add payment date and due payment list. in due sheet.
i have two sheets for making bills, call charges and tax invoice, from that two sheets i want to make a new sheet for list of customers with amount details.
i am attaching the file here to understand easily
Please provide help for which formula to use and how to use.
thanks
Mukund Vyas