Macro to total, move, and save

[NickJ29]

Hello, and thank you in advance for any help you may provide. Now that thats out of the way, on to the issue.

Regrettably, I am unable to pull up any of the VBA text that I have, (not at home, nor have my flashdrive) though it doesn't work, so it doesn't really matter. What I am trying to do is, have a table where things are added or subtracted via positive or negative integers. I want said table to total them, and then add them to another cell that displays the running total so far. After it has made said total and transfer, I would like it to save the running totals in thier respective cells, and await for the next tally to be done.

I'm sorry this is so convoluted, I know visual aids help big time, and if there is no response to this by the time I get to my flashdrive, I'll attempt to upload the table here.

Thanks again!!

[davesexcel]

Can you supply a sample workbook for somebody to work with? Showing. the original layout and what your end result should be

[NickJ29]

Yeah, I dummied up the basics, which I will attach below. Once I make it to my flashdrive, I'll put the entire workbook up.

Edit 01/28/09 06:01am: Since my VBA knowledge is so scant, the text code I had (I got from a friend) was scraped, and I can't seem to re-locate it. Either way, since it wasn't doing anything but telling me there was a command error, I don't see the point of trying to track it down again. I will if needed though.

[davesexcel]

Still not sure what you want, do you want to add totals to an existing Number?

Please Login or Register  to view this content.