How to move rows in a Sheet?

Hi,

I'm trying to do the following:

If a cell in a row has a certain value (always the same), it should move to the bottom of the sheet (after the last row). If it has another value, it should move on the top of the row.

How to do this?


Thanks!

Why not simply add a helper column with a simple formula to return TRUE or
FALSE if that value is present, and then sort on the helper column?

--
HTH

Bob Phillips

"Ekser" <Ekser.1vngyb_1127207108.837@excelforum-nospam.com> wrote in message
news:Ekser.1vngyb_1127207108.837@excelforum-nospam.com...
>
> Hi,
>
> I'm trying to do the following:
>
> If a cell in a row has a certain value (always the same), it should
> move to the bottom of the sheet (after the last row). If it has another
> value, it should move on the top of the row.
>
> How to do this?
>
>
> Thanks!
>
>
> --
> Ekser
> ------------------------------------------------------------------------
> Ekser's Profile:
http://www.excelforum.com/member.php...o&userid=11400
> View this thread: http://www.excelforum.com/showthread...hreadid=469096
>