loop VBA request
I post below earlier on but I couldnt see the thread, if duplicated please
exscute me. I have 3 columns contain names(unknown, may duplicated and dynamic row), date and amount; I am looking a way to get a sum and count on data that: 1) date is equal to or greater than today, then 2) loop thru name and subtotal on each customer 3) sum subtotal if value is equal or above 10k 3) count 2) with same name treat as once Tks |
loop VBA request
Seeker:
Your post is not entirely clear.. notice that you have had no responses. If the customers are not sorted in order, then you will have to loop through the data once for each customer that fits the criteria. Since you want totals, I would find a customer, sum them up using your criteria, and post the customer name and totals to A DIFFERENT worksheet. I have written similar applications where the solution is just posted to another worksheet. For example, you find a date that meets your criteria. Then find every occurrence of that customer, do the math, then post the totals to another worksheet, keeping track of the last row posted in the other worksheet. Keep looping, posting each customer total to the next available row in the other worksheet. The programming for this could be somewhat involved, but not too difficult. Regards, Rich Locus, Logicwurks, LLC -- Rich Locus Logicwurks, LLC "Seeker" wrote: I post below earlier on but I couldnt see the thread, if duplicated please exscute me. I have 3 columns contain names(unknown, may duplicated and dynamic row), date and amount; I am looking a way to get a sum and count on data that: 1) date is equal to or greater than today, then 2) loop thru name and subtotal on each customer 3) sum subtotal if value is equal or above 10k 3) count 2) with same name treat as once Tks |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com