View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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