macro to copy from tabA to tabB depending on conditions

[sncb]

Hi All,

Im using data from tab A where the number of records change daily(copying data from report). Every morning I copy data from a report into tab A and then I want to run a macro which will give the totals in tabB depending on the records of tabA.

Just to explain, on top is tab A and below is B.
everyday the number of records in tabA changes. eg I could have bolts and seats added to the Germany category but in the end I have to put the totals for that category under the country header in Tab B. could anyone recommend a macro code for it. Thanks in advance.

Excel Workbook
	A	B	C	D
1				Germany
2
3	EDC	Product	Ncode	Qty
4	FDC	Rims	AB	0
5	FDC	Rims	AB	0
6	FDC	Rims	AB	0
7	FDC	Rims	AB	0
8	FDC	Wheels	CD	160
9	FDC	Wheels	CD	0
10	FDC	Wheels	CD	250
11
12
13				Italy
14
15	EDC	Product	Ncode	Qty
16	MDC	Wheels	CD	100
17	MDC	Wheels	CD	540
18	MDC	Wheels	CD	0
19	MDC	Bolts	ZA	0
20	MDC	Bolts	ZA	400
21	MDC	Bolts	ZA	200
Sheet3

Excel 2010

Excel Workbook
	G	H	I	J
7	Country	Product	Ncode	Qty
8	Germany	Wheels	CD	410
9	Germany	Bolts	ZA	0
10	Germany	Rims	RM	0
11	Germany	Seats	SA	0
12	Italy	Wheels	CD	640
13	Italy	Bolts	ZA	600
14	Italy	Rims	RM	0
15	Italy	Seats	SA	0
Sheet3

Excel 2010

 

[sncb]

just FYi..the records under each country and for each record are separated by colour(tab A, col E) which i've not shown in the columns..