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
Bookmarks