Just like the Subject line says, I am trying to move whole columns around
based on the heading text. So, if heading text says "Accession number" I
want it to be in column E, and if it says X, I want it to be in column A.
Basically we will be getting files from somebody and the columns may not
always be aligned to the code I have already written, so I would like to have
code to look at the first row and based on what it says in the first row,
move whole columns in order without deleting any of the records. How can I
do this? Any help would be greatly appreciated. THANKS!