copy paste data with multiple selected ranges from sheet to sheet

Hi Friends,

Following is the code which i sorted out with the help of this forum earlier,
This code will copy data from range A to N continuously from Sheet1 and
paste in to Sheet2 along with filter criterias(see code)

Please Login or Register  to view this content.

All I need is instead of continous selection of range from A to N I want specific ranges such as A,B,D,F & H only to be copied and pasted in sheet2.I dont want rest of the ranges to be copied and pasted in sheet2

Hope my explanation is clear.

Please provide me a solution.

Hi,

use this code for select non contignous columns

Please Login or Register  to view this content.

I hope it help a bit

Best Regards

Hi Thanks for the response.

Can anyone compile with my code so that it works perfect.
I'm getting errors in compilation

Please any help!

Hi,

Sorry for delayed answer.

simply try this (I don't know if it is what you need but I hope it will help)

Please Login or Register  to view this content.

Best Regards