Linking cells: can sub-cells move with their master-cell when sorting?

charlesdh · #2 06-30-2015, 05:02 PM

HI,

You can do a "Custom" sort.
Here is a Recorded macro based on you sample

Code:

Sub Macro1()
'
' Macro1 Macro

    
    ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("A3:A16") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Sheet1").Sort
        .SetRange Range("A3:B16")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move emails from one folder to another	smiler44	Outlook	9	11-20-2014 03:02 PM
Move files from one folder to another	obasanla	Word	1	09-28-2012 04:42 PM
Move conversation to folder after replying	karlads	Outlook	0	01-28-2012 12:52 PM
Rule to move sent messages to a specific folder	LouisOscar	Outlook	1	08-17-2011 05:42 AM
How to move pics in excel to another folder?	SPI	Excel	1	08-19-2008 11:58 AM