Hi,
I know how to use the advance filter to extract the unique category, but I
want to know how to calculate subtotal for each unique group and transfer all
these info to another worksheet, in code?

database:
apple,nz
apple,usa
orange,aus
apple,india
grape,aus

newsheet:
apple,3
orange,1
grape,1

Anyone?