Advance filter with subtotal on Column B

**vijanand1279** · 02-10-2011, 06:26 AM

Hi

I am looking for a macro to advance filter names as new sheet with sub total on Column B "Production.

Please help See attached for sample.

Regards,
Vijay

**TMS** · 02-10-2011, 06:59 AM

You could record the actions you take manually:

Please Login or Register  to view this content.

Tidied up, it would look like this:

Please Login or Register  to view this content.

Edit: to cater for variable numbers of rows, use this:

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

Regards

**vijanand1279** · 02-10-2011, 10:40 AM

This gives sub total in new sheet. Whereas I am looking for a macro to create new sheets for each Name (Unique) like Vijay, X, and A sheets with the subtotal.

Please help!

**TMS** · 02-10-2011, 11:01 AM

I suspect the phrase you were looking for was "thank you for your help so far but ..."

Your OP did not clearly specify your requirements and your sample workbook gave no indication of the output you expected or hoped for.

I have explained how you can record your manual actions to produce some "raw code" and also how it can be tidied up and made re-usable.

I suggest you have a go at this yourself and see how far you get.

Please don't hesitate to come back if you have a specific problem you need help with.

Regards

**vijanand1279** · 02-10-2011, 12:43 PM

Please help

Hi,

I have attached my sample file.

Sheet DATA is with original data. I want Each of the names to be moved to New sheets with the name like Vijay, X, A with sub total in each sheet.
I have created the three sheet for sample
See next three sheet to my sample

Regards,
Vijay

Originally Posted by TMShucks

I suspect the phrase you were looking for was "thank you for your help so far but ..."

Your OP did not clearly specify your requirements and your sample workbook gave no indication of the output you expected or hoped for.

I have explained how you can record your manual actions to produce some "raw code" and also how it can be tidied up and made re-usable.

I suggest you have a go at this yourself and see how far you get.

Please don't hesitate to come back if you have a specific problem you need help with.

Regards