Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
I need to sort columns, except for the first two, and the last. Just
the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
Hi
Mark your range of columns, DataSortOptionssort Left to Right -- Regards Roger Govier "Bernie" wrote in message ups.com... I need to sort columns, except for the first two, and the last. Just the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
Thank you Roger, but I wasn't clear enough. I need it in macro form.
Thanks, Bern Roger Govier wrote: Hi Mark your range of columns, DataSortOptionssort Left to Right -- Regards Roger Govier "Bernie" wrote in message ups.com... I need to sort columns, except for the first two, and the last. Just the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
Try recording a macro when you do it manually???????
Bernie wrote: Thank you Roger, but I wasn't clear enough. I need it in macro form. Thanks, Bern Roger Govier wrote: Hi Mark your range of columns, DataSortOptionssort Left to Right -- Regards Roger Govier "Bernie" wrote in message ups.com... I need to sort columns, except for the first two, and the last. Just the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
Bernie
The macro recorder is a very handy tool. Gord Dibben MS Excel MVP On 29 Dec 2006 09:46:08 -0800, "Bernie" wrote: Thank you Roger, but I wasn't clear enough. I need it in macro form. Thanks, Bern Roger Govier wrote: Hi Mark your range of columns, DataSortOptionssort Left to Right -- Regards Roger Govier "Bernie" wrote in message ups.com... I need to sort columns, except for the first two, and the last. Just the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Columns
I did do it manually but i don't know how to write the macro to use the
range of column d through column X becuause I add columns all the time. bern Gord Dibben wrote: Bernie The macro recorder is a very handy tool. Gord Dibben MS Excel MVP On 29 Dec 2006 09:46:08 -0800, "Bernie" wrote: Thank you Roger, but I wasn't clear enough. I need it in macro form. Thanks, Bern Roger Govier wrote: Hi Mark your range of columns, DataSortOptionssort Left to Right -- Regards Roger Govier "Bernie" wrote in message ups.com... I need to sort columns, except for the first two, and the last. Just the ones in the middle. A column will be added in the middle when another macro is run to add. Thanks, Bern |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting automatically by columns | Excel Discussion (Misc queries) | |||
Sorting by Two Columns | Excel Worksheet Functions | |||
How do I link two columns for sorting? | Excel Discussion (Misc queries) | |||
Macro sorting by 4 columns | Excel Discussion (Misc queries) | |||
sorting data across multiple columns | Excel Discussion (Misc queries) |