+ Reply to Thread
Results 1 to 6 of 6

Macro that evaluates rows of dates, inserts blank rows between different weeks

  1. #1
    Forum Contributor
    Join Date
    11-05-2006
    Posts
    123

    Macro that evaluates rows of dates, inserts blank rows between different weeks

    The data in my sample sheet has been sorted by dates (Column G). I would like to insert a blank row between the rows where one weeks ends and another begins. I need VBA code because this will be appended to a larger macro I am working on.
    Attached Files Attached Files
    Last edited by Wedge120; 11-27-2014 at 12:40 AM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro that evaluates rows of dates, inserts blank rows between different weeks

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    11-05-2006
    Posts
    123

    Re: Macro that evaluates rows of dates, inserts blank rows between different weeks

    Can you explain this line in layman's terms?
    Please Login or Register  to view this content.

    The code works well, btw.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro that evaluates rows of dates, inserts blank rows between different weeks

    Well - that means that if the absolute value of the difference in date (which is the number of days between the dates) is more than two - Glad it's working

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro that evaluates rows of dates, inserts blank rows between different weeks

    Thanks for the rep!

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro that evaluates rows of dates, inserts blank rows between different weeks

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Need Macro that inserts two rows with data after value changes
    By KapitalD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2014, 11:03 PM
  2. Replies: 9
    Last Post: 01-13-2014, 01:49 PM
  3. [SOLVED] Macro that inserts rows stopped working
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 09:57 AM
  4. Macro that Inserts a row in between rows (with formulas etc)
    By How How in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2013, 07:49 AM

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