Copy and Paste into new workbook

[course1]

I am trying to copy and paste multiple columns from a large excel document into a new workbook. I just need one certian tab and multiple colmuns that are not side by side. I am sure there is an easy way I tried the advanced filter but it isnt allowing me to do columns that arent right by eachother - can anyone if theres a short formula show an example so column A, B, J, L sorry I am sure this is pretty easy I just am not too good with excel

 

[Joe4]

Just hold the CTRL key as you select the columns you want to copy.
Then go to where you want to paste the first one and paste.
If you had select columns A, B, and L from the source, it will paste them to consecutive columns A, B, and C in your destination.

 

[zCatLady]

Thank you! I've been wanting to do this for a long time. This works perfectly!

 

[course1]

still using that advanced function in data?

 

[Joe4]

still using that advanced function in data?

Not sure what you mean by that...

 

[course1]

Never mind I got it thanks so much worked for me too!

 

[Joe4]

You are welcome.
Glad I was able to help!