Ok I have Three columns of data. I look at a cell within column three,
say C4. In D4 I type a word that is within C4 and it searches all of
column A and B for that word. If that word is found, those cells are
highlighted.

That part works..

Now what I would like to do is setup a cell, so that once the
conditions are met and the matching cells within the A & B are
highlighted.. that those highlighted cells get copied into a cell
within another column, say E4.


Any way to do this?


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