Multiple Tabs Help - Display Any "unchecked" Items

[beehy]

Hi there,

First time poster...

I have created a Timeline task list in excel that uses multiple tabs.
Each tab represents a month, and each month has a to do list.
I set these lists up so that once a task is completed, you double click the "Done?" column and a check mark appears.

What I would like to do, is create another tab that pulls all outstanding items from each of the 12 to do list tabs. (An outstanding items list). Ideally I would like this sheet to pull the entire row of any item that does not have a checkmark in the "Done?" column for the whole workbook.

I've tried searching through boards to find a solution to this and have not been able to find anything.

Please help

Thanks!

 

[beehy]

Still struggling with this one, if anyone has some suggestions I'll be happy to see them!

Thanks

 

[VoG]

It would be easier if you entered X in a column (say A) to denote done then use code like

Sub Summary()
Dim i As Long, LR As Long, j As Long
For i = 1 To 12
    With Sheets(i)
        LR = .Range("A" & Rows.Count).End(xlUp).Row
        For j = 1 To LR
            If .Range("A" & j).Value = "" Then .Rows(j).Copy Destination:=Sheets("Summary").Range("A" & Rows.Count).End(xlUp).Offset(1)
        Next j
    End With
Next i
End Sub