I've created an IF formula to return a value in sheet 1 if sheet 2 contains
phrase X. Is there any way to set up a macro so it automatically does this
for all the sheets in the book?