Solved: Copy Columns and paste in different sequence

[wibbers2000]

I have drawn a blank on the attached and as a result would appreciate and assitance you can.

I have 2 options and I am not sure which one would be better or easier.

I have a sheet called "orders".

I would like to select all the columns and copy the data.


option 1

Then I would like to select the "full" sheet and paste the data in a different column sequence, i.e. column a into c, d into B, b into a and c into d.

Or

option 2

Is it better to just copy all data from orders to full and then; cut and insert the columns where I want them?


regards
Paul

[Bob Phillips]

You cannot do 1 as such. You can either do 2, or copy and paste one column at a time from source to target.

[wibbers2000]

Thanks XLD.

Think I will try your last option as it seams simplist.

Paul

[Bob Phillips]

I agree with that. the macro recorder can help you get the code very easily.