Is there a way to copy multiple non adjacent columns in excel?

[VashHT]

I'm not sure if this is possible, but I have to sift through a lot of data doing the same thing and if there is a shortcut it would save me a ton of time.

Basically what I need to do is this:
-I have a lot of excel files with the same format of data, however the rows are of varying lengths.
-I need to copy a few columns out of each file and paste it into a new workbook, the columns I need are non-adjacent, but when I copy them they need to be all adjacent. The columns I need to copy are the same for each file.

Is there a way to speed up doing this? So far I've been going into each file, copying each column one by one into a new sheet, but since I am doing the same thing I was hoping there was a shortcut to doing it.

 

[Binky]

If you hold down control and select all of the non-adjacent columns, then copy, then paste to the new sheet, they will paste in consecutive columns.

You could also write a macro to do this pretty easily.