| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort one column and entire rows get sorted
I want to sort one column in ascending mode and all rows get shifte too, depending how this column get sorted. View in excel sheet e.g. A B C A B C 1 2 A CC 1 1 C BB 2 3 B AA = Sort column A= 2 2 A CC 3 1 C BB 3 3 B AA : : : : : : : : Can anyone help me how to write VBA-code to sort one column and the rows changes in the same way? Does anyone now how to pick out one row and copy it to another sheet? Best regards Lar ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
| my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
| Can excel sort entire rows of data like access? | Excel Worksheet Functions | |||
| I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
Threaded Mode
