Split excel spreadsheet on lines

[Steel811]

I am looking to split a single excel spreadsheet into multiple worksheets based on the line numbers. The master spreadsheet has 35000 lines to it, and I would like to split it every 100 lines, if possible. Can this be done in VBScript?

Thanks,
Sheel

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Steel811]

To be honest, I haven't developed any code, as I have no clue even where to start, other than defining the excel object.

Sorry...
Sheel

 

[PHV]

Use the macro recorder in excel to discover a starting point.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886