Copy and Paste VBA

Another contributor helped me with this code but need another variation of it. I need to copy all data from SourceData to Destination workbook but code I'm using does not work correctly since it uses a filter criteria. Appreciate any feedback!

Please Login or Register  to view this content.

See if this is how you wanted.

Please Login or Register  to view this content.

Hello @KerahJoy. How about this post?

Data was over written in column headers of Destination table........

Sorry MikeVol but ran into problem with error ("pivot table can not overlap.......")

I don't understand what you are talking about.

Better upload before/after dest sheets, clearly showing what you are trying to do rather than posting the code that is not working as you want.

Good luck.

Good day @KerahJoy. Yes, sorry, my version from your previous topic is no longer suitable since these examples are already different from the previous ones. Take the code that I provided for you @jindon. it works and everything transfers data correctly. Good luck.