Importing data and converting weekly to monthly data given a start date.

[Ch0o0ps]

Hi all,
Please excuse a beginners question.

I need help creating a macro that takes the data from “weekly update” and imports this data to a sheet in “monthly data”
“Monthly data” might already have data that needs to be removed before new data is imported.
The data in “weekly data” (column J:M) needs to be imported under the right month in “monthly data”.

Cell E4 and H4 is determining the period covered by weekly information.
Since “weekly update” is generated from a db and if the query time period is different I.e Cell E4 the week numbers in J:M will change as well. So if cell E4 was 20/03/2011 cells J:M would be Week 13, Week 14, Week 15, Week 16

Looking for all help I can get.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1								Weekly update
2
3
4	Site:	16	Forecast Date:		28/02/2011		-->	15/08/2011		Planner:	mrx
5
6	PART_NO	DESCRIPTION	TYPE_DESIGNATION	PLANNER	CUSTOMER	Std Lot Size	DIM_QUALITY	PART_STATUS	Total Qty	Week 10	Week 11	Week 12	Week 13
7	1111111	bla bla1	dddd1	mrx	name1	25,000	25000 PCS/ROLL	A	3,350,000.00	0.00	0.00	0.00	0.00
8	1111112	bla bla2	dddd2	mrx	name2	200,000	100000PCS/ROLL	A	4,920,000.00	0.00	100.00	0.00	0.00
9	1111113	bla bla3	dddd3	mrx	name3	30,000	30000 PCS/ROLL	A	200,000.00	0.00	0.00	100.00	0.00
10	1111114	bla bla4	dddd4	mrx	name4	200,000	4000 PCS/ROLL	A	15,992,000.00	0.00	100.00	0.00	100.00
Weekly update

Excel 2003

Excel Workbook
	A	B	C	D	E	F	G	H
1	Part No	Part Description	Customer	Jan-10	Feb-10	Mar-10	Apr-10	May-10
2	1111111	bla bla1	name1	-	-	-	-	-
3	1111112	bla bla2	name2	115,000	124,905	74,930	111,685	182,777
4	1111113	bla bla3	name3	-	-	-	-	-
5	1111114	bla bla4	name4	172,000	-	-	-	-
Monthly data

Excel 2003