Hi All

I really need your knowledge today peeps.

OK so this is what I'm working with - I have a query which I want to do two things with.

Firstly - When the query is run, I want it to automatically save it to a location of my choosing and then from every time I run the query it will automatically update that Excel file

Secondly after saving, I want it to run a macro to conditionally format Column E of the file with a duplication formula

=countif(E:E,E2)>1

Is this possible?

Thanks in advance

Craig