ExcelBanter - use "Filter" to filter one range in many worksheets at a time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use "Filter" to filter one range in many worksheets at a time (https://www.excelbanter.com/excel-worksheet-functions/152397-use-filter-filter-one-range-many-worksheets-time.html)

arrowofsun

use "Filter" to filter one range in many worksheets at a time

I want to filter one range in many worksheets at a time .
because i have 38 worksheets . and in every worksheet i want to filter the
range A1:E101 .
I don't know how to do with the LIST RANGE in "Advanced Filter"

All times are GMT +1. The time now is 03:06 AM.