Dear Sir,
Column A has customer name
Column K is the Cheque number
Column C is the Invoice number being allocated.
I wanted to make a summary customer wise
Like Column
A ) customer name,
B) Cheque number
C) Reference number from Column G
D Date of Entry from column B
E ) Debit amount from Column M
F) Deposit in from Column D
G) Remark as “on account” if Colum C doesn’t show Invoice number like M1819 or M1920
As show in Sheet1
Columns are only for example it can be rearranged if needed.
Column A has customer name
Column K is the Cheque number
Column C is the Invoice number being allocated.
I wanted to make a summary customer wise
Like Column
A ) customer name,
B) Cheque number
C) Reference number from Column G
D Date of Entry from column B
E ) Debit amount from Column M
F) Deposit in from Column D
G) Remark as “on account” if Colum C doesn’t show Invoice number like M1819 or M1920
As show in Sheet1
Columns are only for example it can be rearranged if needed.