vba to count number and place in table.

[saravanan1981]

Hi,
I have data in sheet "Employee Data". In Column L i have gender and in column O I have Relation.

I wants to count the members relatio wise and gender wise and put the numbers in Sheet "Summary"

Example given in sheet "Example"

[FDibbins]

You cont need VBA for this (you posted in VBA forum)
B3=COUNTIFS('Employee Data'!$L:$L,Summary!B$2,'Employee Data'!$O:$O,Summary!$A3)
copied down and across as needed

[saravanan1981]

This formula doesnt count Others i.e. Nephew, Brother and Sister on Others category

[FDibbins]

Because those categories do not exist in your table. If you add them to col A, and add my formula, then it will count those as well.

Saying my formula not counting "nephews", would be the same as saying it doesnt count grandmothers - it's not in the table.

[FDibbins]

If you want to lump all non-specific relations under Other, try this...
=COUNTIFS('Employee Data'!$L:$L,Summary!B$2)-(F10+F6)

[saravanan1981]

I am looking for VBA.

Reason being is I have similar data in many format. SO that I can use same VBA for all types of by changing range