i need to split excel work sheet into multiple sheets

i need to split excel work sheet into multiple sheets depending on number of rows

Well, if you want some help you will need to give more detail than that. Are you looking for a formula solution, or a macro? What does your data look like, and what is the criteria for splitting the worksheet? Post a sample workbook showing what you have and what you would like to achieve, and describe your problem more fully, then someone might be able to help you.

Pete