marksawan111
09-16-2016, 05:12 AM
Hello guys,
Many thanks for this great forum, I am including a clear sample file of the sheet I need vba for,
as you can see in my Daily sales sheet, I enter the sales data with customers names and payments (debit,credit) for each customer, on top I have cell O4 which sums the total that is owed to my company, which is in this case ($175,000), however I can't find the right filter or vba to be able to filter a list of the clients that owes this debits that totaled to the $175,000.
currently I can put the name of each client and punch the search criteria macro button and it give me the client's name and remaining balance.
however how can I develope a filter to be able get a list of customers with debts only and exclude the 0 balance customers with a push of a button ?
or maybe get a list of all customers with there remaining balances even if it is 0, insteas of having to find who owes the money manually.
I am ready for any questions if anything is not clear enough, and I am including the complete sample file.
I do not mind to set up this function on a separate new sheet if it is easier, as long as I get the feed from the same daily sales sheet.
many thanks again in advance........
Mark Swan
Many thanks for this great forum, I am including a clear sample file of the sheet I need vba for,
as you can see in my Daily sales sheet, I enter the sales data with customers names and payments (debit,credit) for each customer, on top I have cell O4 which sums the total that is owed to my company, which is in this case ($175,000), however I can't find the right filter or vba to be able to filter a list of the clients that owes this debits that totaled to the $175,000.
currently I can put the name of each client and punch the search criteria macro button and it give me the client's name and remaining balance.
however how can I develope a filter to be able get a list of customers with debts only and exclude the 0 balance customers with a push of a button ?
or maybe get a list of all customers with there remaining balances even if it is 0, insteas of having to find who owes the money manually.
I am ready for any questions if anything is not clear enough, and I am including the complete sample file.
I do not mind to set up this function on a separate new sheet if it is easier, as long as I get the feed from the same daily sales sheet.
many thanks again in advance........
Mark Swan