I recently ran into an issue with some code I was running that used an advanced filter to copy data from one workbook to the other. I assumed it was bad code somewhere but I discovered that manually recreating and executing the advanced filter resulted in the same issue. I am trying to filter on a column that only holds True/False values but it will always return 0 entries. I assume that because the adv filter itself uses True/False, there is some conflict there but I could not find anyone else with the same issue. I'm hoping someone has an easy workaround for this issue. I pasted a simple example below. Thanks!
Advanced Filter True False.xlsx
Bookmarks