have a worksheet that is from external data set:
SN,City,Date, SU,MO,TU,WE,TH,FR,SA, QTY ,[weeknum]
I add a column to put WEEKNUM based on date.
the dates are generally the past 13 weeks

what i am wanting to do is, sum each QTY (quantity sold) for each SN (store
number) by WEEKNUM and place results on another ws in same book
where the SN would be COL headings and the weeks in the ROW s.
thanks