Macros in Excel

[shaili]

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.

[JeanRage]

Hi,

Turn on your macro recorder ... and perform he task ...
The code will be written for you ...

HTH

[rwgrietveld]

I think this will help you

Please Login or Register  to view this content.

Note that the Source data is on "Sheet1"
New Sheets will be added to the WB.