How to split excel file into separate workbooks based on number of columns?

[nandana83]

Hello Everyone,

I have a worksheet having around 400 columns and 50k rows of data which might vary in future.

1. I have to split this worksheet into separate excel files with suppose 100 columns in each file.
2. The number of columns in each file can be determined based on some factor as if the file exceeds 255 columns , the data is not being handled by our application.
3. The first column in the file should repeat in all the splitted files as it is the primary key data.

Can anyone please help me out with this as I am very much new to macros and VBscripting for excel.

Thanks in advance!!

[RHCPgergo]

Hi,

why do you need macro for this? Why not just copy the columns with ctrl C ctrl V to a new workbook? You don't need a lot of copying, only 4-5 times, ~100 columns each time.

[nandana83]

Hi RHC,

I have lot of files like that, and there can be chance of getting more than 400 columns. Thats why I am looking out for a macro or an automation.