+ Reply to Thread
Results 1 to 4 of 4

macro report for coloured rows

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    32

    macro report for coloured rows

    Morning,

    I have recently put together a sheet that tracks invoices with some CF that highlights any payments not paid within 30 days of an invoice sent out....and I'm wondering if a macro could be written to pull off all rows highlighted in 'red' (which are over 30 days old after invoice was sent) or invoices that are 30days+ and pasted onto another sheet for quicker viewing? Our company has rows of invoices within this sheet and it can take a while going scrolling through.

    Any help on this would be a big help

    Tone

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: macro report for coloured rows

    cant you just filter by color?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-23-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    32

    Re: macro report for coloured rows

    i didn't even think about using that......thanks for replying

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: macro report for coloured rows

    not a problem
    by far easier than a macro

+ 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. How can I count coloured cells (coloured using Conditional Formatting)
    By franfry in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2013, 02:40 PM
  2. Macro to count coloured rows
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2012, 12:35 PM
  3. Macro to remove rows, i.e. reformat a report
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2011, 07:18 AM
  4. [SOLVED] Coloured rows
    By sonic-the-mouse in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-29-2005, 02:05 PM
  5. [SOLVED] Coloured rows
    By sonic-the-mouse in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-28-2005, 09:05 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