Hi
I am really confused how to name this topic but my problem is straight forward.
I have value 100 in A1 and 50 in B1, note that these values may change later.
I want the macro to record formula in C2 as "=(100+50)/A2" and not "=(A1+B1)/A2" so that even if later contents of A1 and B1 are changed, C1 still shows "100" and "50" in the formula as =(100+50)/A2.
I am looking for a Macro code purely based on offset feature as the exact locations of cells can change however relative positions will never change.
Bookmarks