Perhaps you might want to try autofilter (DataFilterAutofilter)
For the sorting bit, you could copy n paste the filtered results into a new
sheet (only the filtered results gets pasted over), then sort it to taste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarig" wrote:
Is there a way that I can I use "Find All" and and get Excel to show me the
result sorted instead of viewing them one at a time.

I cannot use "Sort" as "Find" can pick my criteria anywhere in a cell.
--
tarig