Hi,

I have a noepad file with approximately 720000 lines in it. Is there any
funcion in excel whereby on opening the file the data gets equally divided in
between 12 files or worksheet each containing 60000 rows/lines.

Please provide a formula or utility as I am not aware about programming.

Thanks