Take a look at this worksheet. Doing this sort of thing is a little complex.
First, I inserted a column F on your "Action Items" tab for "Actual Date Completed" as that is the criteria you are using to determine whether items are to be moved.
Then in 'Completed Action Items'!A5 dragged down
The "Action Items'!$A:$A" (shown in red) determines which column you want returned and the
SMALL(INDEX(ROW('Action Items'!$F$5:$F$11)+NOT(ISNUMBER('Action Items'!$F$5:$F$11))*1000,0),ROW(A1))
determines which rows you want returned (ones which have dates in column F)
Is this what you wanted?
Bookmarks