Hi,
I have this code that sorts my data - sortData based on column A - sortDistribGr
lastrow = Cells(Rows.Count, 2).End(xlUp).Row
sortData = "A6:AF"
sortDistribGr = "A6:A"
Range(sortData & lastrow).Sort key1:=Range(sortDistribGr & lastrow), order1:=xlDescending, Header:=xlNo
I would like to do a custom sort instead and the order would be column A - sortData = "A6:AF", column H - sortBr = "H6:H"
and then column N - sortSupervisor = "N6:N"
How do I adapt the code above?
Thanks
I have this code that sorts my data - sortData based on column A - sortDistribGr
lastrow = Cells(Rows.Count, 2).End(xlUp).Row
sortData = "A6:AF"
sortDistribGr = "A6:A"
Range(sortData & lastrow).Sort key1:=Range(sortDistribGr & lastrow), order1:=xlDescending, Header:=xlNo
I would like to do a custom sort instead and the order would be column A - sortData = "A6:AF", column H - sortBr = "H6:H"
and then column N - sortSupervisor = "N6:N"
How do I adapt the code above?
Thanks