Maybe this will help:

Sub Dtail()
Dim fRng As Range
Dim lRng As Range
Set lRng = ActiveCell
With Sheets("Daily Recap").Range("A2:J22500")
Set fRng = .Find(lRng.Value)
End With
If Not fRng Is Nothing Then
fRng.EntireRow.ShowDetail = True
Sheets("Daily Recap").Activate
fRng.Select
End If
End Sub

Regards
Rowan

Bryce wrote:
I want to be able to select a cell within worksheet named "Summary" which is
an account #, and the macro searches down the account # on another existing
worksheet named "Daily Recap" within cell range A2:J22500
the data range in "Daily Recap" is grouped/hidden. i want the macro to take
me directly to that cell and open up the grouped rows (but only those rows.
not the other grouped rows on the worksheet) and show me the cell data.

Is this possible?? If not, do you know how to code the first part. It would
be so great to push a macro button (after selecting a specific cell) and
being automatically taken to the more detailed record of that account. I know
i can use the built-in FIND (control+F) function. If it's too hard to figure
out, can i just have a macro which will pop-up the FIND search function
window. Having a easy-to-use-and click Macro Button will be a nice dumb-down
feature for me & my co-workers when dealing with the massive range of data.

Thanks, Bryce