I may need to do a couple formulas for this one, or possibly try to sort the dates, because the dates are all over the place for any given part number. I am thinking of maybe a VLOOKUP, to find the matching part number in the master list, then a SUMIF, for the date range that will add the quantities within a month range,( it would be easier if it were a calendar month, but it has to be within a numerical month, i.e. 6/6/14-7/6/14), then a "=> 50% of AADQ, then a copy and paste of the order #, order date, ordered p/n, and ordered qty., I simply just don't have the excel acumen to compile that formula to make it work, also, I am not an expert on VBA, which I think would be an easier option for this solution. Any suggestions? Thanks.