VBA Code Needed to Spilt main worksheet by weekly

[krjoshi]

Folks,

The attached workbook has a "Master" sheet with some data by day (33 days), is there any way to spilt the sheets by weekly by using vba. Please refer the attached workbook for more information.

Thanks in advance.

Joshi

[rylo]

Hi

Why do the weeks start with 22 march when the heading and data both contain 21 march?

rylo

[krjoshi]

Hi rylo,

Sorry, its should be started from 21st. It was a typing error. can you please help me?


Thanks,
Joshi

[rylo]

Hi

Try this. It assumes that your workbook is in the same order as the example file, with sheets wk1 - wk5 already in the workbook.

Please Login or Register  to view this content.

rylo

[krjoshi]

Hi rylo,

Thanks for your help. The code is working great if the sheets week1 to week5 exist in the workbook. Actually what I am looking for, automatically add new sheets starting from week1 to week5 (If the sheet name (week1 to week5) exist, delete the sheets first then create new). And do the same method by using your above codes.

Thanks in advance.

Joshi

[rylo]

Joshi

Here you are

Please Login or Register  to view this content.

rylo