Excel: Sample Macros

Links:

  1. https://trumpexcel.com/excel-macro-examples/ 24 macros, E.g. convert to values, sort sheets
  2. https://excelchamps.com/blog/useful-macro-codes-for-vba-newcomers/ 99 macros e.g. send via email
  3. https://www.ablebits.com/office-addins-blog/2018/12/19/delete-blank-lines-excel/ Remove empty rows in data
  4. https://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html Split table into several sheets
  5. https://www.extendoffice.com/documents/excel/785-excel-save-export-sheet-as-new-workbook.html Save each sheet as an individual file