create automatic statement for multiple customers, which must include inv # from another sheet and also group them under customers
I have sheet A “customers”, sheet b “Sales” and sheet c “payments”. Under “customers” i have different categories i.e. bar, membership, clothing, etc, which contains updated running totals of all sales and payments. First i want to group all invoices under the customer name in “customers” with inv date, inv total and inv number and […]