Selecting Table Conditionally
There is an Excel file that teaches how to perform the Selecting Table Conditionally operation.
Excel Professional Selecting Table Conditionally
This workbook demonstrates selecting table conditionally using VBA macros on a 500-row data layout.
Hope it is useful.