FSt1, Hi,
Your solution did not directly address my problem, but that was my fault
because I was not clear. However, your formula helped me address several
other issues, that I had on another worksheet so your reply helped me a load.
Thanks again for all your invaluable help.

Best Regards,
Malcolm

"FSt1" wrote:

hi
=IF(OR('Hskp Assign'!C10={"","BLOCK","S"}),"",'Hskp Assign'!C10)

that should cover BLOCK or S.

regards
FSt1

"Malcolm" wrote:

Yesterday I was given a solution to a problem I had when copying text from
cells in the source sheet to the destination sheet. The formula:
=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)
was to prevent text from copying to the destination sheet if the word
“BLOCK” appeared in the source sheet. I have been trying to rework the
formula to only copy the text if the letter “S” appears in the source sheet.
I have not had any success. Please help!
Thanks,
Malcolm