Page 231 - IT 402 v2.0 class 10
P. 231
Step 5: Sorted data will appear on the screen. lick on Stop ecording option. OpenO ce asic Macros
dialog appears on the screen.
Step 6: Click on ‘New Module’ button. ‘New Module’ dialog box appears on the screen.
Step 7: Type the name of the module.
Step 8: Click on ‘OK’ button.
6
8
7
Step 9: Click on ‘Save’ button.
Step 10: To use the created macro for sorting data in ascending order, let’s try in a new set of data.
Step 11: Select the cells. Click on ‘Tools’ menu and then select ‘Macro’ option.
Step 12: A sub-menu appears on the screen. Select ‘Run Macro’ option. ‘Macro Selector’ window appears on
the screen.
Step 13: ‘Selecting the Macro for sorting data.
Step 14: ‘Click on ‘Run’ button.
More About Spreadsheet 229

