Bill
If you wish, send me a small file direct via email showing your data
layout and an explanation of what you want to happen (copy what to where,
followed by copying another what to another where, etc.). I'll work up some
code for you. My email address is . Remove the "nop"
from this address. HTH Otto
"Bill A" wrote in
message ...

Thanks for the response. I wasn't clear about my data layout. My headers
that separate segments only occupy 3 cells horizontal so I went to
column "D" in the data & did "End-Dn" so it would stop when it came to
the open cell in the header row. If the number of rows of data in the
first segment changed ,the macro would still go to the original
stopping point in column D. I hope that is more clear.
Meanwhile I'll try to incorperate the search routine you suggested.
Thanks a lot.


--
Bill A
------------------------------------------------------------------------
Bill A's Profile:
http://www.excelforum.com/member.php...o&userid=31480
View this thread: http://www.excelforum.com/showthread...hreadid=511577