Deleting "0" rows

[elad]

Hi.

I have a sheet (travelstat.xls) that gets data from underlaying subsheets (line_1.xls, Line_2.xls....etc.. ). The number of rows in the subsheet will not be constant, so I have made enough rows in the travelsheet to be sure it would not overwrite cells. This gives med many blank rows that I have to delete manualy after the subsheets are linked. Is it possible to have a formula that check for "0" rows and delete them? See attachment for more details.

Thanks for any help

Elad
Norway

[mubashir aziz]

With combination of AutoFilter & Goto Command you can do the trick ......Insert a blank Row in above of your sheet and in cell enter the below formula ......

G1=IF(OR(ISBLANK(A2:F2),ISNONTEXT(A2:F2)=0),"0","HI")
this is array formula and don't forget to press Ctrl + Shift + Enter after entering the formula ...

Now use auto filter and select 0 ......
Press F5 > Special > Select Visible Cells Only ...Press OK
Now Go in Edit and Select delete rows .... All the blank rows and rows having 0 values will be deleted ......