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
Bookmarks