How do I write a macro that copies columns into a list and inserts some words in between? Like follows:
John Doe 1256 856 Jane Doe 5462 564 Tom...
becomes
John Doe word word word word 1256 word word 856 Jane Doe word word word word word 5462 word word 564 Tom.....
The word is constant in that it is between the data a fix number of times (4 and 2 in this example). There are about 300 columns that I need to rip the data from into a list.
The golden rule for Excel macros is to turn on the macro recorder, perform the action you want automated two or three times and then have a look at the recorded macro.
You usually just need to replace the three separate actions by a For or While loop that processes all your data.
Ah,and if you want to switch between different worksheets in Excel (because you have your source data in one sheet and want to store your results in a second one, for example), remember to set Application.Screenupdating to False before entering your loop, and to True after completing the loop, this will speed up the execution time quite a bit.