Biff, Hi,
This one did it big guy. Thank you for saving my bacon on more than one
occasion. You are the best. Thanks again.

Best Regards,
Malcolm

"T. Valko" wrote:

Ok, if I understand what you want then try:

=IF('Hskp Assign'!C10="s","s","")


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
Biff, Hi,
Since you gave me the original formula, let me apologize for not being
more
precise. It is a new (the only) condition.

Best regards,
Malcolm

"T. Valko" wrote:

=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)
I have been trying to rework the formula to only
copy the text if the letter "S" appears in the source sheet.

Is that an additional condition or is it a new (the only) condition?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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



.



.