Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Thx for the advice on my problem few post down!
But now I have a new problem :/ Lets say there is a number in i.e. A10 and in two next rows in the same column (A11, A12...). And now I want the sum oif those three rows in for example A15. Now, thats not a problem to do, but this is: If the user writes a number in A13, I want the sumary in the A15 move to A16 and to sum up the number in A13. I hope you understand the problem. So, if a user enters only one number (for example 1, in A14), the sumary in A16 needs to move to A17 and that 1 (from the A14) needs to sum to the whole sumary. So that sumary is moving all the time lower and lower. How to do something like that? It would be alot easier if there was something like a FOR function like in C (programing). And if a user deletes a number in a column (like A12), all the number that were under it need to move one row higher. IS that possible? ;) -- -- How does it sound when Darth Vader snores?! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
moving cell contents (automatically) | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Moving from cell to cell is very slow!! | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions |