Separate Every XX Rows Into New Sheet

Hey Guys,

Brand new to this website. I've been able to learn a lot reading through previous threads in my career but thought I'd finally join.

I was hoping for some help. I have a spreadsheet that data dumps everything into 1 sheet. Can I some how write a code and or formula to take every 5 rows and dump them into a new sheet.

So for the example below, that is all originally on sheet 1. Is there an easy way for me to copy (or cut) and paste rows 6-10 on a new sheet #2, then rows 11-14 on new sheet #3?

Example:
Row 1: Subject #1
Row 2: Category A
Row 3: Category B
Row 4: Category C
Row 5:
Row 6: Subject #2
Row 7: Category A
Row 8: Category B
Row 9: Category C
Row 10:
Row 11: Subject #3
Row 12: Category A
Row 13: Category B
Row 14: Category C

I really do appreciate any input and help.

Thanks,
Sean

I think this should do what you want

Please Login or Register  to view this content.