Sorting and copying columns (Forms)

Hi this is exactly what i needed, thankyou very much indeed.

Is this going to be simple to copy across to another worksheet, I have no VB experience but am assuming a few tweeks to sheet names and ranges in the code once i copy across will be all that is needed?

Thanks a lot,

Dan

Hi Dan,

Yes it should be basically as simple as that. I used range names in the macro so you'll need to make sure you replicate those.

Rgds

Hi Richard,
Your green button macro is great.How can I modify it to copy the selected columns to another workwork? I should be able to give the workbook a name and save it as well (a save msg box). I have another question. Is it possible to have a desktop icon which basicaly has the same function as your green button but it the process is invisible to the user. That is click the icon, input the excel file name, select the columns, type in the new workbook name and location (typical msg box save as).
Thanks