Hi,

thank you for your advice but this is a slopy way of
programing! what i would like is a strict piece of program
that will search the correct field and if it returns the
correct value, then it will select the entire row and copy
all the contents into sheet 2.

if this is not possible or nobody has a tidyer way of
doing this please can someone consider only copying
specific data as this is only to be used as a mail merge.

i have considered using the offset command and the if not
function.

any suggestions please,

Thank you,

Robert Couchman