Cumulative value

[Anuru]

Dear Experts,

Please look in to the following format. I need to type values in cells J4, M4, P4 and S4 daily and, those values should be accumulated in cells K4, N4, Q4, and T4 respectively.

Important:

** The cumulative figures (K4, N4, Q4, and T4) should not change when new values are daily entered in to J4, M4, P4 and S4.
** If any WRONG value is entered in to J4, M4, P4 and S4 cells, the facility should be there to MINUS it from the CUMULATIVE (K4, N4, Q4, and T4) figure at any time after the document is saved.

Thanks in advance.
Anuruddha

[mehmetcik]

So you want to add the number you type into J4, M4, P4 and S4 daily in cells K4, N4, Q4, and T4 but not change K4, N4, Q4, and T4 .

How does that happen?

[Anuru]

Yes..one guy did this long time back, but I don't find him now. May be he used macros...or something..

Thanks

[mehmetcik]

Read my question carefully.

How can it change daily but not change?

I think I know what you need, you are not asking for the right help.

You will need three macros not one.


right click on the sheet name at the bottom of excel and select view code

paste this code there and close the module.

Please Login or Register  to view this content.

Now click on K4.

[Anuru]

Actually, the requirement is to keep the CUMULATIVE intact when you delete what is entered in to J4, M4, P4 and S4.

In simple way, we can do this by using + sign for adding values in J4, M4, P4 and S4 cells. However, this is cumbersome as the day by day, the numbers are getting longer and longer in J4, M4, P4 and S4 cells.

[mehmetcik]

Ok I have created what I think you need.

The Log is saved on sheet 2.

You correct your mistakes in sheet2

Please Login or Register  to view this content.

[Anuru]

Hi,

Thanks for the hard work. However, there is one problem. When values are entered to "daily Prd" columns such as M4, P4 and S4, the "cumulatives" in K4, N4 and Q4 changes (every value entered in "daily Prd", is added backwards in chain). Pls check..

[mehmetcik]

My mistake.

I forgot to set the macro to look in column 1 for the date, it was looking in column2

Right click on the sheet name at the bottom of Sheet1 and select view code

paste this code there:

Please Login or Register  to view this content.

[Anuru]

Hi..

The "cumulative" value in all the (K4, N4, Q4, and T4) changes to the same value that is entered in to the "daily Prod" columns. they do not retain the "cumulative" value. Please rectify. And please I need to apply the same conditioning to the V4 and W4 cells where daily and cumulative values have to be shown. And, I need you kind response to the following questions.

01. These codes work only for the row no 4, what about the other rows down the sheet..(row 4 to 19 )?
02. If I have to add more rows down the sheet, what changes should I do in the codes?
03. If I have to add more columns, what changes should I do in the codes?

I have again attached the sheet with the additional two columns(V and W).

Thanks

[mehmetcik]

If you want to keep the historical data for all the rows then that is an entirely different problem requiring a completely new spreadsheet and completely new solution.

You said: I need to type values in cells J4, M4, P4 and S4 daily and, those values should be accumulated in cells K4, N4, Q4, and T4 respectively.


This code does that:

Please Login or Register  to view this content.

I suggest that you mark this thread and start a new one stating your requirement clearly.

[Anuru]

Thanks for the guide lines. I will do.