Link cells in different sheets using formula, instead of value

  • I am trying to link a cell to a cell in a different sheet that will update with changes made to the referenced cell. I have been able to do this successfully with linking the cells by value, but then it will not update.

    The main difficulty is that the ranges are identified through an end offset.

    I would like to replace Value with a Formula command, but have had no success. the working value code is as follows:

    I just started working with VBA and greatly appreciate any feedback. I realize this may not be the best approach, but it is the best i have come up with so far.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!