Issue when copying filtered data from 2 workbooks

Hi,

I am trying to copy filtered data from 2 different workbooks in one worksheet. I have a Wb for this year and another for last year. When copying filtered data from last year and this year, it copies only
the data from this year.

Please Login or Register  to view this content.

When I change Wb1 to ThisWorkbook ( meaning Wb1 and Wb2 are identical), it works ,it copies the data twice

What's wrong with my code?

Thank you,

Daniel

Originally Posted by davesexcel

Would you not require the extension for the workbook name as well?

Sorry, of course, in my code there is the extension
By copying, I forgot it.
The file opens, meaning that this is not the issue

I copied the code but I changed the name of the xlsm file.