| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I type text in one cell and have a value auto-enter in 2nd cel
What I would like to accomplish is that if I enter a certain word or phrase
in a cell, I want a pre-determined number to automatically enter into another cell. For example...if I type "Green" into one cell I want the number "2" to be automatically enter into another cell in the same row. For this specific task, I will be entering any of 30 different words that correspond to 10 different numbers, but will be doing this almost a thousand times throughout the spreadsheet....the ability to have the number auto-entered would be a great time saver. Any advice would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I type data into a cell that changes when I click enter - why? | Excel Discussion (Misc queries) | |||
| I type a date (1/05) in a cell, press enter, it reads ####.Why? | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Auto enter data from cell above on enter | Excel Programming | |||
| auto type text onclick in a cell | Excel Programming | |||
Threaded Mode
