Add rows after a specific criteria meet

[Konexcelmath]

Hello again

I have a table from a5 to k200. Every row has a name in column B and from C to hJ numbers. In col I are some criteria. What i want is first to sort the table according the criteria. After because the criteria has different value, in the last row with criteria A add a blank row and then starts the criteria B. When finish the rows with criteria B add a blank row and then starts rows with criteria C etc.

Please for your help, it is somehow urgent.

Thanks

[xladept]

Hi Kon,

Try this:

Please Login or Register  to view this content.

[Konexcelmath]

Ηι thanks for the response
Ok the problem is that i use the macro but after every row it add one more row. What i want is the following:
example:
from rows 5 to 12 i have some entries to all columns (from b until i). In column i and rows 5 to 12 have the same criteria ("AA"). From rows 13 to 20 criteria "BB" and from rows 21 to 25 criteria "CC".
What i want is to add a blank row at row 13 because row12 is the last row with criteria AA. Add a blank row at 21 because row20 is the last row with criteria BB etc. The rows with the criteria are variable.
If you could help me??
Thanks

[xladept]

You have no entry in Column A??

[Konexcelmath]

In column A is only number counting for the entries 1,2,3,4 etc.

[xladept]

Try:

Please Login or Register  to view this content.

[Konexcelmath]

I tried but dosen't work as i want. I attach you a test file that saws the in sheet1 the basic table and in sheet2 the output, and
please if you could help me.

[xladept]

This works on your sample:

Please Login or Register  to view this content.

[Konexcelmath]

Thank you so much it is working as I want. Thanks!!!

[xladept]

You're welcome!