Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [B3]) Is Nothing Then
Dim Sh As Worksheet, sRng As Range
Dim MyAdd As String: Dim Co As Boolean
Range("c3:E999").ClearContents
For Each Sh In Worksheets
Set sRng = Sh.Cells.Find(Target.Value, , xlFormulas, xlWhole)
If Not sRng Is Nothing Then
MyAdd = sRng.Address
Do
With [e65500].End(xlUp).Offset(1)
If Sh.Name <> "Tim kiem" Then
Co = Not Co
.Value = Sh.Name & "." & sRng.Address
.Offset(, -2).Resize(, 2).Value = sRng.Offset(, 1).Resize(, 2).Value
End If
End With
Set sRng = Sh.Cells.FindNext(sRng)
Loop While Not sRng Is Nothing And sRng.Address <> MyAdd
End If
Next Sh
If Co = False Then [c3].Value = "This's nothing"
End If
End Sub