Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking groups of cells in a row so they will sort together
Hello,
Never posted to the group before but have found lots of good advice. I would like to find a way to link groups of cells in a row so they will sort together when I sort in that row. My spreadsheet has 48 columns of data in each of the 15 rows. I would like to sort each row by columns. In each row, the data in column 1 needs to stay next to the data in column 2, column 3 needs to stay with column 4 and so on. How do I write a macro that could sort by the value of the first column in the pair in descending order and keep the value of the second one in the pair in the column next to it. I have not written macros before so I would appreciate as detailed advice as anyone is willing to give. Thanks, Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
sort by groups in excel | Excel Discussion (Misc queries) | |||
Sort Groups of Cells | Excel Worksheet Functions | |||
How can I sort in groups of 3 rows? | Excel Worksheet Functions | |||
Linking Cells and applying a sort | Excel Worksheet Functions |