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

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/deleti...eleteBlankRows

if this helps please click yes, thanks


"aditya" wrote:

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