Results 1 to 8 of 8

Thread: VBA or Macro to add rows between dates

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Manf1976's Avatar
    Join Date
    Jun 2019
    Posts
    4
    Articles
    0
    Excel Version
    Excel 2013

    Exclamation VBA or Macro to add rows between dates

    HI, I have been beating my head against this problem for some time but haven't yet managed to find a solution. I have an extensive spread sheet of financial data that i am trying to transpose into a different format. I am sure a VBA script will do the job but i am very inexperienced in VBA coding and everything i have tired so far has failed.
    I am trying to make this (sample only):
    Index Start Date End Date Monthly Cost
    index 1 01/01/2015 25/04/2015 100
    index 2 02/04/2017 03/06/2017 120
    index 3 03/05/2013 01/08/2013 150

    Look like this:
    Index Start Date End Date Monthly Cost Billing Date
    index 1 15/01/2015 25/04/2015 50 15/01/2015
    index 1 15/01/2015 25/04/2015 100 01/02/2015
    index 1 15/01/2015 25/04/2015 100 01/03/2015
    index 1 15/01/2015 25/04/2015 33.30 01/04/2015
    index 2 10/04/2017 10/06/2017 80 10/04/2017
    index 2 10/04/2017 10/06/2017 120 01/05/2017
    index 2 10/04/2017 10/06/2017 40 01/06/2017
    index 3 05/05/2013 30/08/2013 125 05/05/2013
    index 3 05/05/2013 30/08/2013 150 01/06/2013
    index 3 05/05/2013 30/08/2013 150 01/07/2013
    index 3 05/05/2013 30/08/2013 150 01/08/2013

    I have other data in other columns that i would also need to copy down but it wouldn't need to change just stay aligned to the correct index (in case it makes a difference i am using Excel 2013).

    Any help would be much appreciated.
    Last edited by Manf1976; 2019-06-14 at 02:23 PM.

Posting Permissions

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