Macro For Comparison Of Data Matching

[rajendradk9]

Sheet1						Sheet2
A	B	C=A+B	D=CountOfC	E		A	B	C=A+B	D=CountOfC	E
Name	Value	GROUP	COUNT	Output		Name	Value	GROUP	COUNT	Output
AAA	5	AAA5	1	C1		AAA	5	AAA5	1	C1
AAA	7	AAA7	1	C3		AAA	6.4	AAA6.4	1	C3
AAA	10	AAA10	4	C2		AAA	10	AAA10	2	C2
AAA	10	AAA10	4	C2		AAA	10	AAA10	2	C2
AAA	10	AAA10	4			BBB	4	BBB4	1
AAA	10	AAA10	4			BBB	7.5	BBB7.5	1	C3
BBB	8	BBB8	1	C3		BBB	7.9	BBB7.9	1
BBB	10	BBB10	2	C1		BBB	10	BBB10	2	C1
BBB	10	BBB10	2	C1		BBB	10	BBB10	2	C1
CCC	10	CCC10	1	C2		CCC	10	CCC10	2	C2
CCC	11.3	CCC11.3	1	C3		CCC	10	CCC10	2
						CCC	12	CCC12	1	C3

Note Output require as per below logic in both sheets
C1=Both Sheet Group Total Count Matching Records
C2=Both Sheet Group Total Minimum Count Matching FIFO Records
C3=Both Sheet Group Total Minimum Count Matching Records Based on Roundup value FIFO

 

[rajendradk9]

Dear Experts require your valuable support for Macro/VBA to Compare Data from two sheets & need input as per above in E Column both sheets same workbook.