What I am trying to do is look down Col A in Book1 that will have blank cells
for any matching data, them combine the text from the correspnding cells in
Col B and place it into another cell or book. Have figured out the combining
of text part on its own, its the dealing with the variable bit that I am
stuck on. As you can tell Iam a novice!!

see other post.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
What I am trying to do is look down Col A in Book1 that will have blank
cells
for any matching data, them combine the text from the correspnding cells
in
Col B and place it into another cell or book. Have figured out the
combining
of text part on its own, its the dealing with the variable bit that I am
stuck on. As you can tell Iam a novice!!