Consider the attached image. I have data like this for about 15 columns.
I want to copy paste each column for 2 to 3 times in a different order in another workbook
The order is predefined. please help in writing a macro code to do the same.
say i want the column D copied into columns I and J of another workbook and so on.
Note: i just want the outline program, also it need not necessarily be macro. Any code will do (say shell scripts and such) thanks in advance.
Macro to copy paste columns of excel data to a new workbook