Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to bottom of table
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" a écrit dans le message de ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to bottom of table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move the Pivot Table totals from the bottom row to the t. | Excel Discussion (Misc queries) | |||
Can I move the tabs at the bottom to the top of the page? | Excel Discussion (Misc queries) | |||
How to Move from bottom of one column to top of next | Excel Discussion (Misc queries) | |||
Move to bottom of Column | Excel Programming | |||
How can I take specific rows and move them to the bottom | Excel Worksheet Functions |