is their a macro that will look threw a page of data and report on another
page a list of results based on information in a percific col

colums A to I contain data

want to search col G and do a report on every event that does not contain
"specific text", the report should contain all the data shown on "Data Page"
rows that does not meet the "specific text"

thanks in advance

To get you started look in the vba help index for FIND and then FINDNEXT.
good example given.

--
Don Guillett
SalesAid Software

"Rich" wrote in message
...
is their a macro that will look threw a page of data and report on another
page a list of results based on information in a percific col

colums A to I contain data

want to search col G and do a report on every event that does not contain
"specific text", the report should contain all the data shown on "Data
Page"
rows that does not meet the "specific text"

thanks in advance

This code (adapted from codes provided in this ng) should work (I do not
know VBA).
The selection criteria is entered in a named range €œSalesman€� in sheet SALES.
From your active sheet containing the data run the following
Macro which will copy the entire row to the target sheet (SALES)

Sub CopySales()
Dim ws As Worksheet
Dim cLastRow As Long
Dim i As Long
Dim j As Long

Set ws = ActiveSheet
cLastRow = ws.Cells(Rows.Count, "B").End(xlUp).Row
On Error Resume Next
On Error GoTo 0
j = 1
For i = 1 To cLastRow
If ws.Cells(i, "B").Value = Range("Salesman").Value Then
ws.Cells(i, "B").EntireRow.Copy _
Destination:=Worksheets("Sales").Cells(j + 9, "A")
j = j + 1
End If
Next i

End Sub

--
Robert