H o l a:
Te anexo la macro para buscar ausentes:
Sub BuscarAusente()
'Por.Dante Amor
Set h1 = Sheets("Hoja1")
u = h1.Range("A" & Rows.Count).End(xlUp).Row
If u = 1 Then u = 2
h1.Range("A2:A" & u).ClearContents
j = 2
For Each h In Sheets
If h.Name <> h1.Name Then
Set r = h.Cells
Set b = r.Find("ausente", Lookat:=xlPart)
If Not b Is Nothing Then
ncell = b.Address
Do
'detalle
If h.Cells(b.Row, "A") <> "" Then
nombre = h.Cells(b.Row, "A")
Else
nombre = h.Cells(b.Row, "B")
End If
h1.Cells(j, "A") = h.Name
h1.Cells(j, "B") = b.Row
h1.Cells(j, "C") = nombre
j = j + 1
Set b = r.FindNext(b)
Loop While Not b Is Nothing And b.Address <> ncell
End If
End If
Next
'
For i = 2 To h1.Range("A" & Rows.Count).End(xlUp).Row
hoja = h1.Cells(i, "A")
fila = h1.Cells(i, "B")
Set b = Sheets(hoja).Cells.Find("VALES", Lookat:=xlPart)
If Not b Is Nothing Then
vale = Sheets(hoja).Cells(fila, b.Column)
h1.Cells(i, "D") = vale
End If
Next
MsgBox "Búsqueda terminada"
End Sub
‘
S a l u d o s . D a n t e A m o r. Recuerda valorar la respuesta. G r a c i a s