Can I put a word in one cell and have a number appear in another c

[Jodi]

I keep a sheet that I enter scores like "Excellent" then I enter a "100" in
another cell.
Is there a way to have the number automatically come in when I type the word?

 

[Rick B]

Sheet? Cell? Those are Excel terms. This newsgroup is for questions
about ACCESS, not EXCEL. I suggest you post to an EXCEL newsgroup.

--
Rick B

I keep a sheet that I enter scores like "Excellent" then I enter a "100" in
another cell.
Is there a way to have the number automatically come in when I type the

word?

 

[Dean]

IF you change the word from Cell to field, then the answer is yes.