Attached is a Workbook where Column B (Table1 Worksheet) is filtered and the results for Col A can be recorded in P1, Q1, R1, etc. Currently, it's a bit of a work around to display the values of Col A, C, and F (from a filtered Col B) to be displayed on the Main worksheet.
Is there a better way to display the filtered rows in the Main worksheet?