I need somehow to search column B for the word Budget. If the word budget is found, display a prompt that has an OK button, and once selected, macro continues.
Just looking at formulas, before creating code, I tried:
=SUM(COUNTIF(B:B,"Budget"))
Cells in column B might have a value such as...