Microsoft Excel - need Macro for one file - Asked By anu anu on 11-Feb-14 03:13 AM

hi ,

i have one excel file with some data in bAse work sheet , like

Month	sdsad	sdsad	sdsd	DESC	sdsd	dsad	sdsad	CATOGREY TYPE	CATOGREY Description
Jun-13	asa	12132	erewr	sadsad	sads	221	06-May-13	CATOGREY-A	a
Jun-13	asa	3j1ghj	erewr	sadsad	sads	221	06-May-13	CATOGREY-A	a
Jun-13	asa	12132	erewr	sadsad	sads	221	06-May-13	OTHER CATOGREY	I
Jun-13	asa	3j1ghj	erewr	sadsad	sads	221	06-May-13	CATOGREY-C	G
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	06-May-13	CATOGREY-B	d
Jun-13	asa	3785B001AA	erewr	sadsad	sads	221	06-May-13	CATOGREY-C	G
Jun-13	asa	0453B001AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-A	b
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-C	G
Jun-13	asa	0453B001AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-A	b
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-A	a
Jun-13	asa	0384B001AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-C	G
Jun-13	asa	9634A006AA	erewr	sadsad	sads	221	07-May-13	CATOGREY-C	G
Jun-13	asa	3766B001AA	erewr	sadsad	sads	221	07-May-13	OTHER CATOGREY	K
Jun-13	asa	3766B001AA	erewr	sadsad	sads	221	08-May-13	CATOGREY-A	c
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	08-May-13	CATOGREY-C	G
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	08-May-13	CATOGREY-A	c
Jun-13	asa	3782B001AA	erewr	sadsad	sads	221	08-May-13	CATOGREY-C	G
Jun-13	asa	8641A001AA	erewr	sadsad	sads	221	08-May-13	OTHER CATOGREY	J
Jun-13	asa	0453B001AA	erewr	sadsad	sads	221	08-May-13	CATOGREY-A	a

now i need in summary sheet .data will be calculate like

CATOGREY Type	CASE Description	Jun-13
CATOGREY-A	a	4
	b	2
	c	2
CATOGREY-B	d	1
	e
	F
CATOGREY-C	G	7
CATOGREY-D	H
OTHER CATOGREY	I	1
	J	1
	K	1
	L

thanks
Anu

Hello usha,
You can do pretty much what you want with a Pivot Table.  Much easier than writing a macro.
Regards
Harry