Hi everyone,
I have several ranges in My worksheet. Each range is separated by an empty row .
Each range start With A = 1050
In all ranges A-H column are constant. And I-AT columns are variable.
I need to sort for any range that I-AT columns will be sort by A->Z by columns I.
First table below is wrong and the 2nd is correct.
I will appreciate your help
First table
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have several ranges in My worksheet. Each range is separated by an empty row .
Each range start With A = 1050
In all ranges A-H column are constant. And I-AT columns are variable.
I need to sort for any range that I-AT columns will be sort by A->Z by columns I.
First table below is wrong and the 2nd is correct.
I will appreciate your help
First table
BUKRS | BLART | BLDAT | BUDAT | WAERS | XBLNR | BKTXT | XMWST | BSCHL/NEWBS | HKONT/NEWKO | NEWBK | WRBTR |
1050 | DZ | 02.01.2018 | 02.01.2018 | ILS | RC189000002 | 40 | 112104 | 50 | |||
11 | 7000002 | 50 | |||||||||
1050 | DZ | 02.01.2018 | 02.01.2018 | ILS | RC189000003 | 40 | 121009 | 18 | |||
11 | 7000002 | 36 | |||||||||
40 | 121009 | 18 | |||||||||
2nd tabl | |||||||||||
BUKRS | BLART | BLDAT | BUDAT | WAERS | XBLNR | BKTXT | XMWST | BSCHL/NEWBS | HKONT/NEWKO | NEWBK | WRBTR |
1050 | DZ | 02.01.2018 | 02.01.2018 | ILS | RC189000002 | 11 | 7000002 | 50 | |||
40 | 112104 | 50 | |||||||||
1050 | DZ | 02.01.2018 | 02.01.2018 | ILS | RC189000003 | 11 | 7000002 | 36 | |||
40 | 121009 | 18 | |||||||||
40 | 121009 | 18 | |||||||||
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>