Macro for running total

hello,

Can anyone help me in writing Macro for the below situation:

Date a b c d e
7/1/2013 $12.00 $54.00 $32.00 $48.00 $56.00

The first cell (range "A") is date and other cells (range "B" to "F" - this may further be required to extend) are sales values for the date. Now there will values falling every day underneath this for the remaining month, and the values should have cumulative values generated on the daily basis. For the 1st day of the month the sales value and cumulative value would be the same, now from the 2nd day of the month on-wards the value should add up to its preceding days cumulative value in each cell. How to go about it. Any help would be greatly appreciated.

Thanks.

Sounds to me like you should be able to do this with sum formulas?

Maybe:

Please Login or Register  to view this content.

Thank you for writing, but when I run this code I am getting "runtime error - 1004" Application-defined or Object-defined error". Please let me know on avoiding this error.

yeah.. thanks for your reply, we can achieve this by writing summation (=SUM($A$1:A1)) formula. But I was wondering if any Macro for this will help.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Thank you for writing, but when I run this code I am getting "runtime error - 1004" Application-defined or Object-defined error". Please let me know on avoiding this error.

Originally Posted by XeRo Solus

Sounds to me like you should be able to do this with sum formulas?

yeah.. thanks for your reply, we can achieve this by writing summation (=SUM($A$1:A1)) formula. But I was wondering if any Macro for this will help.

Originally Posted by prakashananth

Thank you for writing, but when I run this code I am getting "runtime error - 1004" Application-defined or Object-defined error". Please let me know on avoiding this error.

Can you attach a file? It works on the data I tested it on without the error.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Originally Posted by JOHN H. DAVIS

Can you attach a file? It works on the data I tested it on without the error.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

oh now it worked...worked like a charm.

Thanks a ton John for your timely help.

You're welcome. Glad to help out, and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.