Excel - Macro to rearrange/add columns in all the sheets based oncolumn header
Hi,
I need to rearrange columns on many sheets in a certain order based on
on column header.
For example, my columns might come into my spreadsheet as
C,B,D,G,A,H,I,F , or as F,B,C,A,D etc.
I want them all sorted say A,B,C,D - the rest of the columns is
irrelevant.
How do I accomplish this ?
TIA
|