Advanced Filter - Pasting two sets of data into the same sheey

[williamsm96]

Hi,

I've created the below macro that uses the advanced filter to filter and copy two sets of data from different sheets into one sheet. However the second set of data pastes over the first because the CopyToRange is the same. How can I change the CopyToRange of the 'Detailed Reg' to be the next empty row?

Please Login or Register  to view this content.

Thanks

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are still relatively new here, I have done it for you this time.)

[williamsm96]

Ali,

Apologies and thank you updating the post!

[JeteMc]

Would appending one of the tables with the other using Get & Transform (Power Query) as demonstrated in the linked tutorial from Highline college be a consideration?
https://www.youtube.com/watch?v=aOQdxhLCuCA
The one change that you will probably want to make is at the 4:00 mark of the tutorial where he produces a connection only to the Data Model, it sounds as if you would rather just produce a table on a new sheet (first selection on the dialog box).
For more specific details on how this could be accomplished with your data please upload a small desensitized sample of the workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[Akuini]

This is untested:

Please Login or Register  to view this content.