Insert Rows Based on criteria (or CountIf?)

[hutch27]

Hello,

I have two tabs, a summary tab, and a Data Tab. The Data Tab is organized like this (from rows 2 to 300 - with each person having a different number in Column E).

Column B	Column E
Person 1 (row 2)	10
Person 2 (row 3)	2
Person 3 (row 4)	0
Person 4 (row 5)...	1
Person 5 ...(row 300)	0

<tbody>
</tbody>

I would like to add rows on the Summary tab (starting in row 4) equal to the total number of people on the Data tab that have a value in Column E > 0.

Therefore, using the example above, the macro would add in 3 new rows (starting on row 4) on the Summary tab, because there are 3 people on the Data Tab that have values in Column E > 0.

Thanks!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Great, this one seems to be working as intended - I appreciate the quick follow up and I hope I was clear with my explanations!