Split master sheet data to multiple sheets in same workbook

Hi,

I have to copy every 50th rows data in the master file to different sheet in the same workbook. For example, 1st 50th row into sheet1, 51th to 100th row to sheet2, 101th-150th data to sheet3 etc.

I'm not a VBA expert and the following hit syntax errors.

I hope someone can help. Thank you very much.

Please Login or Register  to view this content.

Thank you very much