Anybody else then? I'm wanting to use the macro provided above. Which
works great on a single cell, but have it run on multiple cells
automatically. The current macro allows me to highlight a word, then it
will search the database for cells with that word and copy/paste all
matching cells into a new cell. I then highlight another word in the
column and repeat the process. I would like it to go down the column
and do all words that have a match automatcialy, basically running the
macro above over and over.


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