Dear All,
I'm having a very hard time trying sort data in Column C from largest to smallest and also maintaining the row grouping.
Can someone please help me by creating VBA code which can handle this task?
Screenshot below without row grouping
Sheet1
<colgroup><col style="width: 30px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 98px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Screenshot with row grouping
Sheet1
<colgroup><col style="width: 30px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 98px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Your help would be greatly appreciated.
Kind Regards,
Biz
I'm having a very hard time trying sort data in Column C from largest to smallest and also maintaining the row grouping.
Can someone please help me by creating VBA code which can handle this task?
Screenshot below without row grouping
Sheet1
A | B | C | D | E | F | G | H | I | |
1 | Sample | ||||||||
2 | Store No | Store | Amount | ||||||
3 | Parramatta | 50 | |||||||
4 | 60 | Store2 | 20 | ||||||
5 | 70 | Store3 | 30 | ||||||
6 | 80 | Store4 | 100 | ||||||
7 | Westmead | 3 | |||||||
8 | 90 | store 5 | 1 | ||||||
9 | 100 | Store 6 | 2 | ||||||
10 | |||||||||
11 | |||||||||
12 | Desired Result | ||||||||
13 | Store No | Store | Amount | ||||||
14 | 80 | Store4 | 100 | ||||||
15 | Parramatta | 50 | |||||||
16 | 60 | Store2 | 20 | ||||||
17 | 70 | Store3 | 30 | ||||||
18 | Westmead | 3 | |||||||
19 | 90 | store 5 | 1 | ||||||
20 | 100 | Store 6 | 2 | ||||||
21 | |||||||||
22 | |||||||||
23 |
<colgroup><col style="width: 30px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 98px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Formeln der Tabelle | ||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Screenshot with row grouping
Sheet1
A | B | C | D | E | F | G | H | I | |
1 | Sample | ||||||||
2 | Store No | Store | Amount | ||||||
3 | Parramatta | 50 | |||||||
6 | 80 | Store4 | 100 | ||||||
7 | Westmead | 3 | |||||||
10 | |||||||||
11 | |||||||||
12 | Desired Result | ||||||||
13 | Store No | Store | Amount | ||||||
14 | 80 | Store4 | 100 | ||||||
15 | Parramatta | 50 | |||||||
18 | Westmead | 3 | |||||||
21 | |||||||||
22 | |||||||||
23 |
<colgroup><col style="width: 30px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 98px;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Formeln der Tabelle | ||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Your help would be greatly appreciated.
Kind Regards,
Biz