I'm trying to filter a worksheet in one workbook, then paste the results into another workbook. I've managed to get auto filter to work, but in researching the approach this morning, it seems that the advanced filter function is more appropriate. I'm really struggling to understand how to set...