I have an Excel balance sheet with a total at the bottom. On that cell I have a comment that says that the reason the total is X is because of what happens in J2. What happens if I insert another row before that, now my comment is wrong because all the rows jumped up a value.
Is there any way to reference a cell dynamically in an Excel commment?
No comments:
Post a Comment