Hi guys!

I'm having a problem with Excel.. The scenario goes like this.. I have a worksheet named orders_19 (19 may changed since this is just a date). What I wanted to do on the worksheet is to count how many parts order on that certain date. Parts order from 1-7days, 8-14 days, 15-30 days, 31-60 days, 61-90 days 91+ days and the total number of parts order on that day on China and Sydney. 1-7 days is from 03/19/2012, 03/18/2012, 03/17, 03/16, 03/15, 03/14, 03/13.. 8-14 days is from 03/12, 03/11 going backwards so on and so forth. It can be seen on the Created by Column.. The China and Sydney choices can be seen on the Dispatch by Column.. The resulting numbers will be pasted on the EOS workbook. The NETO found on the EOS workbook is not applicable as well as the Deleted column on the EOS workbook, only the Sydney and China rows. Attach are the excel files.. EOS.xlsxsamplewithdispatch.xlsx


I need your help on this.. Thanks..