

Read [Tutorial] Sorting and Filtering data with formulas. So that the other sheet can tell what you've filtered on the sheet with autofilter, you'll have to add a column to the filter containing the SUBTOTAL function. If the filtered range (including headings) is A1:D687, expand the range (Data → Define Range) to include column E. Put =SUBTOTAL(3;A2:A2) in cell E2 and Fill the formula to E687. You can hide column E if you want. Use the values in column E in the formulas on the other sheet as your automatically-filter-with-formulas criteria.Hayukan wrote:It should automatically flow based on their selection.