You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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



.



.