How to automatically remove blank rows in a table using macros

Try this code:

Please Login or Register  to view this content.

The attachment assumes that I only have 26 rows of data on each day tab in the Case tables. The Cases sheet is protected (not with a password) so you don't accidentally delete the many formulas in the B6 to E811 range. You can select the cells and see the formulas in them. Notice the gaps in data as you scroll down. I used the data from sheet '1st' for all of the Case tables on the others sheets. If you select the cells you can see how each section of 26 rows relates to each of the day pages.

So in "1st Worksheet you can see the whole table is not full of data, there are blank rows, but it copies the blank rows into the "Cases" worksheet table anyway. I don't want these blank rows to appear in the "Cases" table, so I want to it to figure out that if there is a blank row, remove it from the "Cases" worksheet table.

If I enter in data in the table in the "1st" worksheet, then the row should automatically appear in the "Cases" table worksheet. At the moment the data appears automatically due to filling in one of the blank rows but I don't want it like that

http://ge.tt/8yUVdNx/v/0

Your issue is the rows are not blank. They contain formulas. In excel, blank means empty. Nothing in the cells. Suggest you change your formula to put an #N/A instead of the "" and then delete the rows based upon cells having #N/A in them.

Your file did not convert properly for me to see everything as I am working on a Excel 2002 version this morning. You have some formula that are not compatible with 2002, but I can see that every cell has a formula in it.

Alan