Reporting from a list

[IGPOD]

I have a list of contract names. I have to provide a status report on contracts that are not fully signed. In Column "A" I have the contract name. in Column "M" I have the Date the Contract is/was completed.

My report lies in Column "N"

What I need is a macro that will search that list of contract names, and based on a blank cell in Column "M" it will provide me ONLY the contracts that are not completed (blank "M" column; because not completed) and only the Contract Name (Column "A") along with the contract notes in the "N" column.

I know someone out there can figure this out much faster than I... I've been trying for days, I can't get anything to work and this is always my goto resource.

I need to report this information onto another sheet in the same workbook... basically using VBA to reference the cells and import the content on my reports page at the click of a button.

Thanks in advance!

Here is an example of what I'm working with:


I just need the capture the information in the yellow and report them to another sheet (sheet2)

[3com]

I have a spreadsheet called Contracts, and another called Reports
The macro searches unsigned contracts in Contract spreadsheet , and copy the name of Contract and the respective Note on the worksheet called Reports.

Sheet <Contracts>

Attachment 118869

Sheet <Reports> after running the macro.



Code...

Sub report()

    Dim nrow As Integer, x As Integer
    nrows = Worksheets("Contracts").UsedRange.Rows.Count 'Sheet containing Contracts, Notes, Dates
    x = 2
    
    For i = 2 To nrows
        If Not IsDate(Worksheets("Contracts").Cells(i, 3).Value) Then
            Me.Cells(x, 1).Value = Worksheets("Contracts").Cells(i, 1).Value 'Contract name
            Me.Cells(x, 2).Value = Worksheets("Contracts").Cells(i, 2).Value 'Note
            x = x + 1
        End If
    Next i

End Sub

Note: I placed code onto sheet called <Report>. You has to change data to suit your needs.

Edit:

and import the content on my reports page at the click of a button.

Notice button (8 ball) in pic 1 above. This button run this macro for me. Then you need add some button to QAT.

http://office.microsoft.com/en-gb/ex...001234105.aspx


HTH