Thanks Tom. This worked.
One quick follow up question:

How do I change your code so that this (conditional) search
and copy begins in column F after row 7? Rows 1 to 6 should
be completely ignored. (They contain titles.)

Thanks.


---
Message posted from http://www.ExcelForum.com/