Hi.
I have a worksheet called "agenda" and another called "Result"
I need to return the worksheet "Output" the "Clients" (which is in worksheet "agenda"), according to cell "C1" and cells "A2", "C2", "E2", "G2", "I2 "plnilha the" Result "
I did a manual example for you, can understand.
Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range If Target.Address(0, 0) = "C1" Then With Worksheets("AGENDA") For Each rng In .UsedRange.Rows(1).Find(What:=Me.Range("C1").Value, LookAt:=xlWhole).MergeArea.Cells(1).Offset(2, 2).Offset(, -2).Resize(.UsedRange.Rows.Count - 1).Cells '........... Next rng End With End If End Sub
Cross-Post
http://www.excelfox.com/forum/f2/ext...-criteria-633/
Bookmarks