View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi[_2_] avi[_2_] is offline
external usenet poster
 
Posts: 15
Default 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