LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rearrange columns Madiya Excel Programming 0 June 22nd 09 03:02 PM
Macro to rearrange/add columns based on column header? drdavidge[_2_] Excel Programming 2 July 8th 06 02:27 AM
Rearrange columns using VBA ktpack[_5_] Excel Programming 7 July 7th 06 08:57 PM
Macro help to rearrange excel table Alan[_31_] Excel Programming 1 April 19th 06 10:05 PM
hide columns based on header macro Todd L. Excel Programming 4 December 7th 04 05:53 PM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"