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!


--
Ekser
------------------------------------------------------------------------
Ekser's Profile: http://www.excelforum.com/member.php...o&userid=11400
View this thread: http://www.excelforum.com/showthread...hreadid=469096

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" wrote in message
...

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