Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
additon of values automatically
hi
i have the following problem but no solution, i want to format the cells B2:R99 as follow for example B4 (like all others) if u enter a number it should add it automatically for example: Step1: input in B4 of 4 - output: 4 - algorithmus in formulr bar: 4 Step1: input in B4 of 5 - output: 9 - algorithmus in formulr bar: =4+5 Step1: input in B4 of 3 - output 12 -algorithmus in formulr bar = 4+5+3 Step1: input in B4 of -4 output 8 - algorithmus in formulr bar =4+5+3-4 i want to create a material list for a project for others, but this list contains of 500 positions and 5 tables but i want these data to be pursue-able . i am not really good in makro programming, i have an additions algorithmus makro witch adds but it does not give the algorithmus in the formular bar just the vallue of the output, (for example only vallue 9 instead of '=4+5+7-7') hope someone could help me kind regards mario |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
additon of values automatically
See one answer in microsoft.public.excel:
Please don't post the same message to multiple groups - it just fragments your answers and potentially wastes the time of those replying. See http://cpearson.com/excel/newposte.htm for tips on using these groups effectively. In article lekom.at, "Mario" wrote: hi i have the following problem but no solution, i want to format the cells B2:R99 as follow for example B4 (like all others) if u enter a number it should add it automatically for example: Step1: input in B4 of 4 - output: 4 - algorithmus in formulr bar: 4 Step1: input in B4 of 5 - output: 9 - algorithmus in formulr bar: =4+5 Step1: input in B4 of 3 - output 12 -algorithmus in formulr bar = 4+5+3 Step1: input in B4 of -4 output 8 - algorithmus in formulr bar =4+5+3-4 i want to create a material list for a project for others, but this list contains of 500 positions and 5 tables but i want these data to be pursue-able . i am not really good in makro programming, i have an additions algorithmus makro witch adds but it does not give the algorithmus in the formular bar just the vallue of the output, (for example only vallue 9 instead of '=4+5+7-7') hope someone could help me kind regards mario |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Entering Values | Excel Worksheet Functions | |||
Automatically Convert values to $M | Charts and Charting in Excel | |||
Automatically copy values | Excel Worksheet Functions | |||
All values automatically change to zero | Excel Discussion (Misc queries) | |||
How to copy values in various rows automatically | Excel Discussion (Misc queries) |