Hi all,
I have a LOT of data (>10,000 rows long and about 15 columns wide) which I regularly have to go through and insert two columns after the column headed 'Date'. Although I will always have a heading titled 'Date' the size and places of my heading vary - Date will not always be in column C.
Therefore I am trying to write a macro that will automatically search row1 for 'Date' and add two columns after it - could anyone help me with this please? It sounds so simple!
I have tried recording a macro to change but... well, it didn't really work!
Thanks in advance for your help.
Bookmarks