Help with excel formula......Please

Fatpigeon · 26 Sep 2009 at 12:18

Hi guys, i'm hoping one of you can help me (im a bit of a noob). Im trying to get a running total working in excel but not having much luck. What i would like it to do is when i put a value in cell C7 on sheet 1, it would add it to a running total in cell C7 on sheet 2, is this even possible. I've tried google but can only find formulas that work on the same sheet.

Any help would be great

Thanks in advance

Fatpigeon · 26 Sep 2009 at 13:35

Thanks for that, but whenever i edit any other cell on sheet1, the value in C7 gets added to sheet 2 again, if that makes sense.

Fatpigeon · 26 Sep 2009 at 20:39

Namsnik said:
If you mean:

type 3 into Sheet1!C7
Sheet2!A1=3
type 4 into Sheet1!C7
Sheet2!A1=7
type 5 into Sheet1!C7
Sheet2!A1=12
Then this is not possible without macros (VBA).

Thats what I meant, I found a VBA code for doing it with 2 cells on the same sheet, but cant find anything for using 2 sheets.

Fatpigeon · 27 Sep 2009 at 09:45

Thanks for doing the code for me, i'll give it a try when i get to work tomorrow.

Fatpigeon · 28 Sep 2009 at 09:44

That seems to have done the trick, thanks a lot for your help.