+ Reply to Thread
Results 1 to 4 of 4

align all these series by date using VBA

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    9

    align all these series by date using VBA

    From the original dataset, there are different series with different start date ie: some start with 2003 and some start from 2005 etc ….
    Anyone know how can I align all these series by date by VBA instead of doing that manually for each series ?
    align by date.xlsx

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: align all these series by date using VBA

    See if the attached works for you
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: align all these series by date using VBA

    Thank Jindon. This code is amazing !!! I tried to modify it to include the date for the series that has date starts later.
    Do you know how can I do it ?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: align all these series by date using VBA

    Quote Originally Posted by h1196844 View Post
    I tried to modify it to include the date for the series that has date starts later.
    I don't understand what you are trying to say.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1