Copying used range from one sheet to another

All the columns will be there but there will other columsn within the sheet that will have forumla's in them.

I have attached an example.

Originally Posted by arlu1201

This is what i had asked you in post5. Can you explain some more regarding the columns changing position? Do you mean to say the 12 columns will be there but in mixed order? Or there are chances that some of the columns might not be there at all?