| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Organising data | Excel Discussion (Misc queries) | |||
| Sum multiple worksheet sales data by month | Excel Worksheet Functions | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
| re-organising a table of data | Excel Programming | |||
Threaded Mode
