delete empty rows

  • Thread starter Thread starter vrijbergen
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top