Returning entire row
I want to Pull Data from a sheet name (Daily Sales Sheet) to another sheet (Payable).
This is the entire row from Daily Sales Sheet.
In (Daily Sales Sheet) there is a column by the name of payment method. If any cell in column marked as Payable, that entire row having customer name, service and other details should reflect in (Payable) sheet.
Also, if there is a duplicate entry of that customer as Payable, I don't want it to be reflected the entire row again, just the value of "Balance" column would be added in previous entry so that I know this customer owes this much.
Is it possible?