Need macro to copy columns to a new sheet in a different order

Hi,

Can someone please write this simple macro for me? I'm totally useless with macros.

Summary:
Create new worksheet (can be any name)
Copy columns from worksheet original (name might change, so use activeworksheet) to their new positions on the new worksheet

Actual size will be quite big, so use aslong

A number of columns will stay in their original positions - those are marked green. Everything else moves and is marked as such.

Thanks for any help you can offer.

Came up with this, but it doesn't work when I have the Paste section
Without the paste section it works but I get lots of errors because its pasting formulas and not values
I tried it with PasteSpecial too but didn't work either

Please Login or Register  to view this content.

[edit]
Figures, all I needed were line breaks between Copy and Sheets to fix it -.-