Split the excel data in worksheet to save it in two separate excel files

[sat1591]

Hi Friends,

I need a help from you all for making a macro which helps me save some time.

My query is very simple. Please find the below.

Excel data consists of 1,000,000 rows and 50 columns with header in one worksheet.

I need a macro such a way that when i run, the excel should split into two workbooks with 500,000 rows and 50 columns (exact half) respectively, Header in main workbook should copy and paste in that two workbooks and save with different filename like Split(1).xlsx and Split(2).xlsx.

I have browsed many websites and watched many videos but I did not find any solution for this. Please help me

Thanks in advance.

 

[Kaper]

do not crosspost - the same question appeared here:
[SOLVED]Split the excel data in worksheet to save it in two separate excel files