Multiplying An Excel Table Based on Subtotals

[odinnn]

Hi everybody;

I have an excel table consisting of many changable subtables including formulas and hidden rows. Each sub table has its own subtotal row. As you can see in the sample file I want to split the table into seperate sheets based on the subtables. Now, I do this by copy past at each time. And the number of subtables may change. IWhat I want is to produce a separate page for each sub-table with the name of the table.
You can see the sample file in the attachement.

Thank you in advance.

[jindon]

Try

Please Login or Register  to view this content.

[odinnn]

Thank you for your quick reply.

In our original document there are numeric values like 101.1.1.0000.1.2 instead of "Group name". How can I revise the code in this case.

[odinnn]

Try

Please Login or Register  to view this content.

Thank you for your quick reply.

In our original document there are numeric values like 101.1.1.0000.1.2 instead of "Group name". How can I revise the code in this case.

[jindon]

If the data layouts are different, it will not work.
You should upload more realistic data sets.

[odinnn]

If the data layouts are different, it will not work.
You should upload more realistic data sets.

I have updated the file.

[jindon]

Change to

Please Login or Register  to view this content.

[odinnn]

Thank you so much.

[odinnn]

Change to

Please Login or Register  to view this content.

Sorry, but in original document rows and columns number is a bit different. I could'nt adopt your codes into my original doc. I uploaded fully original document. Could you please adopt your codes to new sample.

Thanks in advance.

[jindon]

Please Login or Register  to view this content.

[odinnn]

Please Login or Register  to view this content.

Thank you so much for your support and attention.