+ Reply to Thread
Results 1 to 6 of 6

VBA Code Needed to Spilt main worksheet by weekly

  1. 03-18-2012, 10:19 AM #1
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question VBA Code Needed to Spilt main worksheet by weekly

    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-18-2012, 07:23 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: VBA Code Needed to Spilt main worksheet by weekly

    Hi

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

    rylo
    Reply With QuoteRegister To Reply
  3. 03-18-2012, 10:24 PM #3
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Code Needed to Spilt main worksheet by weekly

    Hi rylo,

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


    Thanks,
    Joshi
    Reply With QuoteRegister To Reply
  4. 03-18-2012, 11:21 PM #4
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: VBA Code Needed to Spilt main worksheet by weekly

    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
    Reply With QuoteRegister To Reply
  5. 03-19-2012, 11:42 AM #5
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Code Needed to Spilt main worksheet by weekly

    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
    Last edited by krjoshi; 03-19-2012 at 11:46 AM.
    Reply With QuoteRegister To Reply
  6. 03-19-2012, 05:47 PM #6
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: VBA Code Needed to Spilt main worksheet by weekly

    Joshi

    Here you are

    Please Login or Register  to view this content.
    rylo
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1