Need a VBA code

I am in need of a VBA code to create multiple workbooks from main file and copying specific rows to each like copying from row 1 to 77 to one workbook and 78 to 154 to another workbook and so on till data of workbook is finished. Actually i have to send the data to different people from main file and i need this to create different workbooks with their respective data as i have a code to send mails with attachments to different people.