View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seeker Seeker is offline
external usenet poster
 
Posts: 137
Default 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