+ Reply to Thread
Results 1 to 2 of 2

Macro to copy rows and populate month/year based on start date?

  1. #1
    Registered User
    Join Date
    10-26-2016
    Location
    Vancouver, BC
    MS-Off Ver
    Professional Plus 2013
    Posts
    1

    Question Macro to copy rows and populate month/year based on start date?

    Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the data looks now:

    Rep name Start Date
    Alice 10/1/2016
    Dave 8/1/2016

    And below are the rows I need to end up with (the date format changes as well, but my main concern is generating the rows in an automated way rather than copying/pasting):

    Rep name Start Date
    Alice October, 2016
    Alice November, 2016
    Alice December, 2016
    Dave August, 2016
    Dave September, 2016
    Dave October, 2016
    Dave November, 2016
    Dave December, 2016


    Thanks so much for any help you can offer!

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy rows and populate month/year based on start date?

    FWIW:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 10-26-2016 at 03:52 PM.

+ 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. start month, end month based on year and period
    By stephme55 in forum Excel General
    Replies: 4
    Last Post: 09-06-2016, 04:56 PM
  2. Calculate Start & End Date & Month for Each Week In Fiscal Year
    By sarndt01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2014, 02:14 PM
  3. Replies: 5
    Last Post: 08-04-2014, 06:42 PM
  4. [SOLVED] Macro to copy data from source workbook to target, based on current month of the year
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-27-2014, 05:41 PM
  5. [SOLVED] Employee Utilization for the Year based on Start Date and End Date
    By nickydharia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2014, 05:55 AM
  6. Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  7. Replies: 0
    Last Post: 07-03-2012, 03:52 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