Delete Rows Based on the Entry in Another Cell

[HangMan]

I have a workbook which has a hidden worksheet named 'Template'. There is some code that creates new worksheets based on criteria in the Summary worksheet, so if you run the macro called CreateSheets, it will create new worksheets for every code which has a 'Complete' status on the Summary sheet, putting the relevant code in cell C5 on the newly created sheets and giving the worksheet the same name as the code.

On these newly created sheets are some SUMIFS formula to sum values (see very simplified sample attached). The values in cells E10:E19 (always the same range) change based on the entry in cell C5 and this results in the values in some cells in E10:E19 being zero.

What I want to happen is that when the new worksheets are generated any rows in the range E10:E19 on each newly created sheet that show zero are automatically deleted. So on the attached sample:

on sheet AB123, rows 10, 13, 15 and 19 would be deleted
on sheet XZ689 rows 11, 14, 15, 18 and 19 would be deleted
on sheet PQ792 rows 13, 14, 16, 17 and 18 would be deleted and so on for each sheet

Is there a way to achieve this by adding to the code?

The code to generate the new worksheets, kindly created by skywriter is:

Please Login or Register  to view this content.

Many thanks

[GC Excel]

Hello Hangman,

See if this works :

Please Login or Register  to view this content.

[HangMan]

Hi GC Excel,

Many thanks, that seems to be working a treat...

If I also has a second range on each sheet where I want to do the same thing, is it simply a case of repeating this part of the code?

Please Login or Register  to view this content.

so say e.g. I also need to delete rows with zero values in column G on rows 30 to 50 could I just add

Please Login or Register  to view this content.

or would I need to set up another variable, e.g. Dim k As Integer and add this?

Please Login or Register  to view this content.

[GC Excel]

Hello HangMan,

If you add this, you can use the same variable :

Please Login or Register  to view this content.

Or even, like this :

Please Login or Register  to view this content.