Top 10 report
Sort by column B from highest to lowest and highlight the top 10.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Sort A1:Z1000 by column B, high to low
- Highlight the 10 highest in B2:B1000
- Style the header row A1:Z1
- Auto-fit the columns
Use it in MacroRoni: open the Starter gallery, search for "Top 10 report", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More reports macros
ReportsMake a report look professionalDark header row, banded rows, borders, frozen header and fitted columns.Doesn't change valuesReportsPrint-ready reportLandscape on one page wide, header repeated on every page, page numbers in the footer.Doesn't change valuesReportsSave the sheet as a PDFFit the sheet to the page and save it as a PDF next to the workbook.Doesn't change values