itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Sort from small or from big using an office script in an excel report

This script will sort the column from A to Z (ascending order) or to Z to A (descending order).

macro excel macro excel

 

When I use the script ?

When I want to sort the column chronologically.

 

How to create the script ?

Read How to create, edit and select an Office Script in an excel report

 

How to create the button to associate it with the script ?

Read How to create a button and associated it to an Office Script in an excel report

 

How is/are the script(s) ?

Copy the code below and paste it into your script. You will see my comments in green if exist so follow the help to adapt to your need.


function main(workbook: ExcelScript.Workbook) {
    // change sheet1 by yours
    let sheet = workbook.getWorksheet("Sheet1");
    // change A2:B10 by yours
    let range = sheet.getRange("A2:B10");
    // change 0 if not column A, i.e column B = 1, column C = 2, etc. 
    // change true by false for descending order
    range.getSort().apply([{key: 0, ascending: true}]);
}

Interesting Topics