Hi there all, does anybody know how/if this can be done.
I have 4 worksheets in 1 spreadsheet. The first 3 worksheets have numerous columns of product info. 1 of those columns has a use by date. I have used conditional format to highlight all dates that have expired.
What I would like to know is, can the rows with the highlighted items be automatically transferred to the 4th worksheet so I then have a list of the expired items from the 3 other worksheets.