Hello!
I have a list of data several thousand rows long. For each time that
123 occurs in column F I would like to copy the text from (same row)
column A and paste it at the bottom of a list that starts in cell Z5.

I currently do it with an Excel List filtered and then copy "Visible
Cells" but I Know there is a cleaner way.

Any Help or direction would be greatly appreciated!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=545452