Organising sales data by month
Workbook €śSales€ť
(A1)Product (B1)Qty (C1)Date
X 2 2/1/2010
X 1 10/1/2010
X 3 5/3/2010
Y 1 8/1/2010
Y 2 5/2/2010
Y 1 3/3/2010
Y 1 5/3/2010
Z 2 3/2/2010
Z 1 5/3/2010
Workbook €śReport€ť
SUMQTY
(A2)Product (B2)Mar10 (C2)Feb10 (D2)Jan10
X 3 0 3
Y 2 2 1
Z 1 2 0
Hi
€śSales€ť is a excel workbook from our sales system.
I would like some code to organise all the sales data found in €śSales€ť and
group it into monthly columns in a new excel file €śReport€ť but being new to
vba I dont know where to start.
In the workbook €śReport€ť:
I want B2 to be the current month and year (Mar10), C2 to be the current
month -1 (Feb10) and so on until I have 12 columns i.e 1 year.
Then I want the SUM of all the QTYs for each month for each product in the
correct column as shown above.
Can anyone help with the code?
Many thanks
Simon
|