If your data is formatted being an Excel table, You'll be able to quickly sort and filter it with the filter buttons within the header row. Recording of your macro commences quickly soon after clicking the Close button. Perform the steps you ought to report and have the macro execute. https://www.customguide.com/excel/if-function-excel