Macro to break and then rejoin formula links

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.

why a macro? Give the cell a name range, then use that?

even with VBA or offset or whatever, how would you know how to find the cell?

Maybe ?:

Please Login or Register  to view this content.

Hi John, awesome

This resolves my first part with a small modification. Now my second part is a bit complicated as I want to break partial formula link as elaborated in following examples.

IF any of following two examples can work, it will work for me.

EXAMPLE 1
A1 = 3
B1 = 4

Original Formula in Cell C1 will be
C1 = A1+B1

I want Macro to change above formula into the following,
C1 = 3 + B1 (So its link is broken with A1 but not broken with B1)

EXAMPLE 2
A1 = 3
B1 = 4

Can a macro put a formula in B1 as follows:
B1 = 4/3*A1