Moves to another sheet when the 30 days is up.

[srgtennis]

Once 30 days is done from the date it was created I want it to pop up in a different work book if possible or at least different sheet. So I know which ones that I need to either extend longer or get rid of.

So B4 through B7 would pop up on the other page saying the 30 days is up so I know that I have to do something with those ones.

I don't want it to move to the other sheet but almost make a copy once the 30 days is up.

[CAntosh]

One possibility is to copy your table on to a second sheet to serve as your "Alerts" sheet, then array enter (confirm with Ctrl + Shift + Enter instead of Enter) the formula below in B4:

=IFERROR(INDEX('Quality Alerts'!B$4:B$25,SMALL(IF('Quality Alerts'!$K$4:$K$25<0,ROW('Quality Alerts'!$K$4:$K$25)-ROW($K$4)+1),ROW(1:1))),"")

Fill it down and right and it will replicate your original table, but it will only show the entries over 30 days old. It should automatically update as you add or alter the original 'Quality Alerts' sheet. Check out the attachment to see if it will do. I've also used conditional formatting to make the blank cells in your original formula appear blank on the '30 days' sheet (the formula returns a zero). Alternatively, you could use an IF clause like this (also array entered):

=IF(IFERROR(INDEX('Quality Alerts'!B$4:B$25,SMALL(IF('Quality Alerts'!$K$4:$K$25<0,ROW('Quality Alerts'!$K$4:$K$25)-ROW($K$4)+1),ROW(1:1))),"")=0,"",IFERROR(INDEX('Quality Alerts'!B$4:B$25,SMALL(IF('Quality Alerts'!$K$4:$K$25<0,ROW('Quality Alerts'!$K$4:$K$25)-ROW($K$4)+1),ROW(1:1))),""))