Hi All,

I have a large worksheet that I wish to split into many smaller worksheets and I was wondering if there is an easy way to split the main sheet and create a new sheet every 400 rows,
e.g. First 400 rows go to sheet1, next 400 to sheet 2 and so on.

Thanks in advance for any replies!

Matt