Hi,
I have multiple sections in a worksheet, see below. Columns A and B is one section, C and D is another section and so on. The first column in each section contains a number and the second text. Whenever a new row is added to any section or when a value within a section is changed (see coloured cells below) I want each section to be sorted based on the number in the column that corresponds to each section. How can I achieve that?
<colgroup><col style="width: 48pt; text-align: center;" span="5" width="64"> <col style="width: 56pt; text-align: center; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <tbody>
</tbody>
I have multiple sections in a worksheet, see below. Columns A and B is one section, C and D is another section and so on. The first column in each section contains a number and the second text. Whenever a new row is added to any section or when a value within a section is changed (see coloured cells below) I want each section to be sorted based on the number in the column that corresponds to each section. How can I achieve that?
| A | B | C | D | E | F |
| 1 | aseff | 4 | qawsfe | 1 | yuiyiu |
| 4 | asfasf | 5 | asfasf | 3 | qwrqwer |
| 5 | afasef | 6 | asff | 5 | wqrwq |
| 2 | asfsaf | 6 | adfaf | 6 | wsfwefe |
| 7 | asfaas | 8 | sdafadf | 7 | edfgef |
| 8 | asfsaf | 8 | ewtrewrt | 9 | qwereqwe |
| 3 | asfasf |
<colgroup><col style="width: 48pt; text-align: center;" span="5" width="64"> <col style="width: 56pt; text-align: center; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <tbody>
</tbody>
