If your data is just not already in a very table, then format it as being a table. This can routinely include a filter button at the very best of each table column. Recording in the macro begins promptly immediately after clicking the Close button. Perform the steps you need https://www.customguide.com/excel/absolute-reference-excel