I currently do alot of manual dividing up of data from one large worksheet into 4-5 seperate worksheets for assignment to analysts. Is there any way to open a master worksheet, then have a macro or something split, lets say 60 rows of data, into 5 seperate worksheets of 12 rows of data each? Same formatting, same type of data. This would just make it much easier than having to copy and paste all necessary data rows to seperate worksheets. Thanks!!
Bookmarks