B
Bagia
Hello,
I am very new at Macros and no experience with VB, but I need to create a
Macro that would allow me to display the formula within the cell to the right
of the Total Value cell. For example
A2=3
A3=6
A4=9
A5=18 (=A2+A3+A4)
C3=5
C4=8
C5=1
C6=14 (=C3+C4+C5)
I want to display the Formula in cell B5 as =A2+A3+A4 and C6 as =C3+C4+C5
and this can be at any place in the worksheet. So, whenever I press the
ENTER key after creating the formula to calculate the sum, I want the system
to display the formula to the right of the cell that contains the sum value.
Is there a way to create a Macro so that I can just press a key combination
to make this work?
Thank you in advance for your help.
I am very new at Macros and no experience with VB, but I need to create a
Macro that would allow me to display the formula within the cell to the right
of the Total Value cell. For example
A2=3
A3=6
A4=9
A5=18 (=A2+A3+A4)
C3=5
C4=8
C5=1
C6=14 (=C3+C4+C5)
I want to display the Formula in cell B5 as =A2+A3+A4 and C6 as =C3+C4+C5
and this can be at any place in the worksheet. So, whenever I press the
ENTER key after creating the formula to calculate the sum, I want the system
to display the formula to the right of the cell that contains the sum value.
Is there a way to create a Macro so that I can just press a key combination
to make this work?
Thank you in advance for your help.