Hi guys,

I need help for making a code to split my master file into multiple files.

My data :

- My data is from A2 to F601
- A1:F1 is the header

My requirements :

- I need a pop up message " how many data per batch ", and when i type like for example 200, there will be 3 excel files in my Import folder ( located in the same folder with my master file )
- The 3 files will have a name and the data { 1st file = File1to200 (containing data of master file from row A2:F201) , 2nd file = File201to400 (data from row A202:F401, 3rd file = File401to600 (data from row A402:F601 } , in short the data will be 200 rows for each file

It will be really helpful if some1 can help me in this problem, i will be glad to provide sample data or further explanation if necessary.
Any kind of help will be appreciated ( The code, an explanation to make the code, or a website that can help me to make the code )

Thanks in advance guys