+ Reply to Thread
Results 1 to 5 of 5

Split data based on date range

  1. #1
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Split data based on date range

    Hi Friends,

    SPLIT DATA.xlsxI required a macro to copy the data based on the date range given in the summery sheet (From and To date) and past in the new sheet with the name mentioned in the summary sheet against the date range.

    Example I have done for “Sequence 01” in the summery sheet manually. I.e. I copied the details from the sheet “Data” from 8th July to 2nd August 2013 and created new sheet in the name of “Sequence01”and pasted the copied details (including header row). Likewise I need to do for the rest of the sequences mentioned in the summery sheet based on the date range given.

    Kindly help to get the macro to split the data as mentioned above.

    Thanks for your support

    Regards,
    Prabhu

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,693

    Re: Split data based on date range

    Pl see attached file with macro.
    Attached Files Attached Files

  3. #3
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Split data based on date range

    Thanks,

    But sheets like Sequence 02,Sequence 03 and Sequence 06 etc are taken one more day extra then the given date.

    i.e for example Sequence 02 to date should be 29-08-2013 but it takes date till 30th Aug 2013.

    Kindly help to modify the same.

    Regards
    Prabhu

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,693

    Re: Split data based on date range

    29th Aug is not there in Data Sheet .That is why it is taking 30th, ie next day. If you want that to be restrict to previous day,
    Change this line
    Please Login or Register  to view this content.
    as
    Please Login or Register  to view this content.

  5. #5
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Split data based on date range

    Thanks!

    Need your help in solving one more bug in this Macro.

    If the date range given in the summary is not available in the sheet"Data" then it should move to next Sequence.

    suppose from and to date is for the year 2012 then the macro stop running. in such case the relevant sequence sheet must be blank and it should move to next sequence.

    Kindly help in amending the macro.

    Regards,
    Prabhu

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to adjust data date range based on analysis range
    By MechEngSk in forum Excel General
    Replies: 1
    Last Post: 09-15-2013, 11:28 PM
  2. [SOLVED] Selecting data from a date range based on the current date
    By ian-sheridan in forum Excel General
    Replies: 12
    Last Post: 06-20-2013, 11:38 AM
  3. [SOLVED] Copy Data Based on Date Range
    By tranjo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 01:30 PM
  4. How to split workbook into multiple workbooks based on date range
    By simoncurrier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 06:50 AM
  5. Replies: 27
    Last Post: 08-17-2011, 05:25 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1