I cannot seem to find a solution to this. I am sure there is one.

I have a data file that I import into excel and I am able to create
input box to have the user insert text to search for what they need.
can get it to return the value of the row it finds the first cas
(There are several). I can also get it to find the last case of i
along with the row but how do I select these rows, and the row
inbetween so I can copy them to another sheet to further filter ou
which information I need?


I hope I was able to explain my problem

Craig Schellenbach

Aim: Drrott

--
Drrott
-----------------------------------------------------------------------
Drrott1's Profile: http://www.excelforum.com/member.php...fo&userid=1546
View this thread: http://www.excelforum.com/showthread.php?threadid=27048