linking cells

[happyman123uk]

How do i link cells ie if i input somethng into say e5 I want it to add 1 to d5
then if i put info into e6 it will add another 1 to d5 making d5 =2

so E5 =lost18
e6 =won 18

then d5 would =2

e7 =won 9

then d5 would =3

but e5 is on 1 sheet2 and d5 is sheet 2 but in same workbook

 

[jproffer]

You can "link" cells by formula.

The formula in D5 would be something like:

=COUNTA(E5:E6) or whatever range you want to cover.


The rest, I'm lost on. Maybe post a screenshot of your workbook before and after your results are entered.

 

[happyman123uk]

Take a look at this web page i have just made up for you to see what i am trying to do


http://myexcelproblem.moonfruit.com/

I have also downloaded the sheet to the web site as well if you want to down load in but it is macro enabled