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