+ Reply to Thread
Results 1 to 2 of 2

How to highlight a row beneath last data entered and to also insert a row beneath that....

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    Chicago, Illinios
    MS-Off Ver
    2007
    Posts
    35

    How to highlight a row beneath last data entered and to also insert a row beneath that....

    Ok, i would like a way to, once you enter the last invoice of the payment in G5 (this instance) that the row directly beneath it gets highlighted in Grey (so in this case it would be row 6) and after it highlights that row grey that it also inserts another blank row beneath that?

    attached is the template.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-14-2015
    Location
    Chicago, Illinios
    MS-Off Ver
    2007
    Posts
    35

    Re: How to highlight a row beneath last data entered and to also insert a row beneath that

    Any ideas?

+ 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. [SOLVED] Help delete all rows beneath last row with data
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2016, 10:49 PM
  2. Auto insert cells row beneath based on cell value
    By waiholi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2016, 06:19 PM
  3. [SOLVED] VBA If Column contains values, copy and insert row beneath
    By Aquabat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 03:47 PM
  4. [SOLVED] VBA If row contains values, copy and insert row beneath
    By Aquabat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2013, 11:06 AM
  5. [SOLVED] Fill in missing values of one row with the rows beneath it if the rows beneath match
    By ilikeexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2012, 02:40 PM
  6. Insert rows beneath cells containing specific text
    By adame in forum Excel General
    Replies: 2
    Last Post: 07-22-2011, 07:07 AM
  7. Filling In Data Beneath Current Rows
    By Jasper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2005, 10:06 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