Hello,
I have the problem with excel´s function SUM.
A1=A2 A2=amount(A3:A6)
I need blocked A1, when I change some number for example A5. A1 contains the number before the change.
Mrice thought the macro, but this macro switched off all function. and I have around 120 sum in excel list. It is crazy, because I must validate each formula.
I reflected. Is it possible, the mathematical formula after the calculation assign to standart number(enter the keyboard).
I know, it is stupidity, but I have any idea to solve it.
Bookmarks