I have a large amount of data in two different worksheets, worksheet 1 and worksheet 2. I am trying to copy all the info from one worksheet to the next, but in a different order.

ie. columns A,B,C in worksheet 1 should be copied into columns B,A,D of worksheet 2.

How can I create a new worksheet and copy certain columns in a given order? The only way I know is to copy it column by column but this takes a very long time.

Thanks!

Yoav