delete empty rows

V

vrijbergen

Hi,

I have the following problem: I have filtered my worksheet for dubble
values but now I have many empty cells and i don't want that.

So i want to rewrite my collums in the following way:

For example: column C has its first value at C21 its second on C45 etc,
I want in the next worksheet Column C to be like: C1=C21 C2=C45 etc and
than automated for all the columns.

Can anyone help me with this problem?

Thanks Michiel
 
N

Nick Hodge

Michiel

Are these complete rows? If so just sort them and they will all move to the
bottom

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top