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


--
vrijbergen
------------------------------------------------------------------------
vrijbergen's Profile: http://www.excelforum.com/member.php...o&userid=27757
View this thread: http://www.excelforum.com/showthread...hreadid=473068

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 Removed)HIS


"vrijbergen" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
> --
> vrijbergen
> ------------------------------------------------------------------------
> vrijbergen's Profile:
> http://www.excelforum.com/member.php...o&userid=27757
> View this thread: http://www.excelforum.com/showthread...hreadid=473068
>