As always, copy/paste your coding efforts here for comment.

--
Don Guillett
SalesAid Software

"Drrott1" wrote in message
...

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 a
input box to have the user insert text to search for what they need. I
can get it to return the value of the row it finds the first case
(There are several). I can also get it to find the last case of it
along with the row but how do I select these rows, and the rows
inbetween so I can copy them to another sheet to further filter out
which information I need?


I hope I was able to explain my problem

Craig Schellenbach

Aim: Drrott1


--
Drrott1
------------------------------------------------------------------------
Drrott1's Profile:
http://www.excelforum.com/member.php...o&userid=15460
View this thread: http://www.excelforum.com/showthread...hreadid=270489