I've got a database with a ID--such as TC38493--in column A, but not in
every row. Instead its the ID followed by more information about that
ID. And the information is contained in more then one cells in the rows
below it. Unfortunately the number of rows of information is not a
regular amount, sometimes its 2 sometimes is 7 rows.

TC389214
Information Information Information
Information Information Information
Information Information Information
TC298315
Information Information Information
Information Information Information
Information Information Information
Information Information Information
Information Information Information
TC073847
Information Information Information
Information Information Information

Then in my second document I've got a lot of these IDs listed. I need
to search Document1 with the ID from Document2 and when it finds
anything it will paste all of the information--whether its 2 rows or
7--back in document2.
Anyone want to write me a program, or at least start me off? I know
the very basics of VBA. If you'd like more information just ask.


--
Taru
------------------------------------------------------------------------
Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494
View this thread: http://www.excelforum.com/showthread...hreadid=553229