delete empty rows

[aditya]

In sheet two i copy data from sheet1 by using If function.
In this pocess some of the rows of sheet2 remain empty which does not
satisfy if function.How can i auto delete these empty rows in sheet2.

thanks in advance

 

[Eduardo]

Hi,
two options, first you can sort the column by empty cells and then delete
them,
second option use a macro as the one in CPearson web

http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

if this helps please click yes, thanks