ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Advanced Filter w/ multiple sheet List Range (https://www.excelbanter.com/excel-worksheet-functions/83789-advanced-filter-w-multiple-sheet-list-range.html)

stickandrock

Advanced Filter w/ multiple sheet List Range
 
I want to create a advanced filter that use multiple sheets same col as a
list range but I am not sure how to format the list range.

Example....

In my YTD Sheet I want to produce a unique list of values (CopyTo with
Unique Records flag on), based the values in Column C of Sheets Jan, Feb,
Mar, Apr, ....


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com