Hi,
I have to split an excel sheet into 3 sheets.
The split should happen column wise.
For example..if there are 10 columns in a sheet ,i have to split this sheet in three sheets.
The first sheet should contain first 3 columns,the second sheet must contain the next 3 columns and the last sheet should contain the remaining 4 columns.
I am supposed to do this using some code and not manually cut and paste the columns.
Please help me and send the code for this.
Thank you.