I'm happy with the way the code works (thanks Skywriter), I have worked out how to append the filtered data to an existing sheet if it already exists, but I just cant seem to do it without the heading row.
I have followed the code in the multiple posts on the subject but keep getting a...