Hello!
I am wondering if it is possible to replace text of a CF formula with new
text given by the user through an input box .
I need it to do this throughout every sheets' CF formulas within a workbook
and every time a new customer is added to the spreadsheet.
I have already made the CF formulas for new customers by entering newa,
newb, newc......newp which need to be replaced with customer names. And I
have already set the range on which to apply the CF rules.
Any ideas?