You've reached the threshold that separates recording macros and
writing code from scratch. From here, to update a formula in a cell,
you'll have to know how to parse strings of text- basically taking the
formula apart letter by letter, and replacing old elements with new.
Can you give an example of the old formula, and what has to be updated?