+ Reply to Thread
Results 1 to 11 of 11

Need to split data via date

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    48

    Need to split data via date

    I have one workbook name "data" in I have one sheet name "sheet 1" which I want to split into different sheets based on date I mentioned in sheet and value in others sheets must be greater zeros. For example I am uploading the sheet in which I have created the two desired sheets as result. Can anyone provide me the macro for this.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-18-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    251

    Re: Need to split data via date

    Hi

    Use
    =INDEX(Sheet1!E:E,MATCH(1, (A2=Sheet1!B:B)*(B2=Sheet1!C:C),0))

    then press Shift+Ctrl + Enter
    Attached Files Attached Files
    Christopher Yap

  3. #3
    Registered User
    Join Date
    03-25-2012
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    48

    Re: Need to split data via date

    This is not what I asked for. That doesn't solve my purpose. I want to split data into different sheets based on date mentioned in sheet 1. I want data like sheet name 26.12.2019 and 27.12.2019. Similarly It should create another sheet for 28.12.2019 and so on.

  4. #4
    Registered User
    Join Date
    03-25-2012
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    48

    Re: Need to split data via date

    looking for help?? does anyone know this with help through macro??

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Need to split data via date

    See next code ... it takes time for the full set of dates ...!

    Please Login or Register  to view this content.
    Last edited by PCI; 12-26-2019 at 04:48 PM. Reason: Code updated vs last column
    - Battle without fear gives no glory - Just try

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,140

    Re: Need to split data via date

    it takes time for the full set of dates
    A bit unorthodox but faster...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,653

    Re: Need to split data via date

    Quote Originally Posted by daga.sachin120887 View Post
    looking for help?? does anyone know this with help through macro??
    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  8. #8
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,308

    Re: Need to split data via date

    Exactly !

    ...

    Similar to "sintek" but with page formatting:
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    03-25-2012
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    48

    Re: Need to split data via date

    Thanks for the support guys...

  10. #10
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,140

    Re: Need to split data via date

    Pleasure...Tx for rep +

  11. #11
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Need to split data via date

    You're welcome
    PCI

+ 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. Split Data to New Sheets based on date.
    By pyarx33 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2016, 08:20 AM
  2. [SOLVED] Split of data into seperate rows using a date range
    By ploppmongo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2014, 12:25 PM
  3. Split Date into Multiple Worksheets based on Data
    By keithm_007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2014, 12:00 PM
  4. Split data based on date range
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2014, 06:30 AM
  5. [SOLVED] Split Month to Date data into Weeks
    By dksodhi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2013, 10:59 PM
  6. [SOLVED] Need to split data according to date and language
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-16-2012, 12:45 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