Move to bottom of table
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
|