Move to bottom of table

I want to move rows with with a certain word in column A to the bottom of all
the rows. How can I do that in a macro?
--
H

Yes:

Either with a macro or in the worksheet without a macro:

Let's say that some cells in column A contain happy. and that those rows
want to be moved to the bottom.

In an un-used column enter:
=IF(A1="happy",99,1) and copy down. Then sort by the new column.


--
Gary's Student


"hfazal" wrote:

> I want to move rows with with a certain word in column A to the bottom of all
> the rows. How can I do that in a macro?
> --
> H

Create a staging column (in unused area) with following formula:
=NOT(ISERROR(SEARCH(""fish"",A1)))

Then sort your data on that columnd ascending.

HTH
--
AP

"hfazal" <[email protected]> a écrit dans le message de
news:[email protected]...
> I want to move rows with with a certain word in column A to the bottom of
all
> the rows. How can I do that in a macro?
> --
> H

Hi,

This works within a worksheet but how would I do this in a macro? Also, the
table is already sorted by other columns, I don't want to screw up this
sorting, I just want to move rows that have certain input in column A to the
bottom of the table... any ideas?

Thanks
Hussein
--
H


"Gary''s Student" wrote:

> Yes:
>
> Either with a macro or in the worksheet without a macro:
>
> Let's say that some cells in column A contain happy. and that those rows
> want to be moved to the bottom.
>
> In an un-used column enter:
> =IF(A1="happy",99,1) and copy down. Then sort by the new column.
>
>
> --
> Gary's Student
>
>
> "hfazal" wrote:
>
> > I want to move rows with with a certain word in column A to the bottom of all
> > the rows. How can I do that in a macro?
> > --
> > H