Copy Specific Columns to Another Sheet

[Aiushta05]

Hi! Kindly help me with my Excel problem.

I have a lot of data on my Sheet1 (from Column A to Column IV). Now, I need to copy certain columns only to Sheet2. Say I need to copy Column A, Column D, Column E, Column O, etc..

How do i do it? Please help me. God Bless!

 

[VoG]

Try like this

Sub CopyCol()
Range("A1,D1,E1,O1").EntireColumn.Copy Destination:=Sheets("Sheet2").Range("A1")
End Sub

 

[Aiushta05]

wow great! thanks VoG!