Formula for moving columns around
Posted on 2012-08-28
Hello Excel experts,
I have a bunch of excel spreadsheets. The columns are not in the order I want.
Is there a formula that will let me move columns from one location to another in one quick "instant" rather than having to have to manually cut and paste copied column individually to a the new location?
Example. I have a column "Z" that I want to insert before Column "B" and a column "T" that I want to insert to before Column "K" -- and so on.
For part 2 of this question, and I don't know if this is possible. Let's say I have several excel spreadsheets in a Word folder. It would be nice if the formula could apply to all of the spreadsheets in that folder.
All of the spreadsheets have the same columns with the same header names and all of the spreadsheets need to have the same columns moved from one column to the new positions as described in the first part of this question. Again, this may not be possible, but thought I would ask.