Reorder the columns in Excel

A

AG

Hi Everyone,

Does anyone know a way to reorder the columns in the Excel spreadsheet
using a macro. The macro that I have written uses cut, and paste at
the appropriate location. But I need to do this many many times before
I get all the columns in order. I am sure there is a better or shorter
way for this. If anyone has any suggestions, please let me know.
Thanks.

-AG
 
F

FSt1

hi
since you didn't tell us what you have nor what it's suppose to be, we can
only make some wild gueess.
have to tried the sort-left-to-right option
2003-data>sort> options button>check sort left to right.
a macro would probable use the same cut and paste routine you are using now
except it would be quicker but we need to know what to cut and where to paste.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using column labels instead of column numbers 1
Randomization of groupings based on value 1
Moving Columns Macro 3
has Excel software updates disabled VBA functions? 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Alt codes 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top