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
|