That is aweome!!

Now, one last thing.. is there a way for me to not have to run the
macro for each line? If not, that's fine. This works the way it is, I
just have to highlite each line then run the macro, which still saves
me a lot of time. But if there is a way to run the macro and all the
matching lines for each match paste into their cells, that would be
very nice.


--
ebraun01
------------------------------------------------------------------------
ebraun01's Profile: http://www.excelforum.com/member.php...o&userid=30340
View this thread: http://www.excelforum.com/showthread...hreadid=506336