OK.........HERE IS A CHALLENGE !!!!

[Michele]

I have a spreadsheet that I use to figure Girls Softball Batting Averages....trouble is...when I open the file to update the number of hits, the exsisting value is deleted and the new number goes in the cell. Instead, I would like for the number that I type to be automaticaly added to the exsisting number.
Would I have to created another row to type the values in or could I just click the exsisting cell ,put in my value and then let the macros do it for me ? and what would the formula be ?

As always Guys....Thanx for your Expert Help !!!

_________________
Despite all my Rage, I am still just a Rat in a Cage ....
This message was edited by Michele on 2002-08-29 09:07
This message was edited by Michele on 2002-08-29 11:56

 

[Dave Patton]

On 2002-08-29 08:26, Michele wrote:
I have a spreadsheet that I use to figure Girls Softball Batting Averages....trouble is...when I open the file to update the number of hits, the exsisting value is deleted and the new number goes in the cell. Instead, I would like for the number that I type to be automaticaly added to the exsisting number.
Would I have to created another row to type the values in or could I just click the exsisting cell ,put in my value and then let the macros do it for me ? and what would the formula be ?

As always Guys....Thanx for your Expert Help !!!

-----

Could you show the formula that you are using?

Is there some reason that the new information cannot be in a new cell?

Hits game 1
Hits game 2
..............
Total

etc
etc
This message was edited by Dave Patton on 2002-08-29 12:05

 

[Michele]

I have NO idea how I did those replies...SORRY :}





============================
You again, huh ?

:wink:

I deleted them.... probably just a glitch in the servers or something

Chris

============================
This message was edited by Chris Davison on 2002-08-29 12:14