I have multiple worksheets but the exact same columns in each(with different
data). I'd like to change the order of the columns, but for all of them at
once. Is this possible?

On Sep 11, 12:50*pm, Change order of columns multiple wkshts <Change
order of columns multiple wrote:
I have multiple worksheets but the exact same columns in each(with different
data). I'd like to change the order of the columns, but for all of them at
once. Is this possible?

It isn't possible to operate on gouped sheets in a macro, you'll have
to loop through your worksheets or do it manually.

Select all the sheets you want to change by holding Ctrl and clicking
on the sheet tab (or by click on the first sheet, holding shift and
clicking on the last sheet to select all of them).

Select the column(s) you want to move, cut them and paste them where
you want to move them. It will duplicate the action on all other
sheets simultaneously. If you have calculations, disable auto calc
first to prevent slow-down. Columns must be adjacent if there are
multiple selections.


Good luck!


Steven