Find and copy
 

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

Find and copy
 

for each c in intersect(activesheet.usedrange, [f:f])
if c.value = 123 then cells(c.row,1).copy
[z65536].end(xlup).offset(1,0)
next


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=545452

Find and copy
 

colofnatu
The code works great! Thanks!!

If I want the text copied to the bottom of a list in a named range on a
different sheet, how would I do that?


--
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