Hi all! I’ve taken on some voluntary work for an animal trust and just need some help (if possible) for the second part of my excel problem.

Part one of removing any rows where to totals equal zero or the rows are blanks is complete. See thread link below:

http://www.excelforum.com/excel-prog...ml#post4124298

I have around 60 or so excel workbooks. Each workbook has 9 worksheets named March, April, May etc through to November.

In column BR of each worksheet I have a totals column, cell type is set to general. Each cell concerned contains =SUM. For ex. =SUM(BP13:BQ13). If the cells in this totals column equal the integer zero only (not 3500, 2440 etc) or is blank I would like the whole row deleted. I would like to do the above from row 13 to 350 inclusive.

I know need to apply the above code (see link) so that it executes on around 60 or so workbooks in the same directory.

Any help would be much appreciated.

Jules