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 Monarch,

Since i do not know if you have any unique identification of columns,
I'll assume that in first cell (row 1) there are letters for columns...


Answer to your query is YES. ROW 1 contains unique identification of
columns.
I want to arrange couple of columns across all the sheets in the same
way since I have them now randomly placed across sheets in different
columns. Namely these a "NUM", "SYS", "DIA", "TAG" etc...

Your code works perfectly on one sheet where 1st row (as you said) has
letters but can you help me with this.
TIA