AdvancedFilter Error 1004 - works in one Excel 2003 workbook but not another

Hi Drewzen,

I have copied your code and tested with new workbook. It's working perfectly for me.
Just make sure once the Sheet Names(Database,AuxList) are correct in new workbook where you are trying.

Thanks,
Ramana