Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populating excel fields
I'd like to be able to auto-populate a cell by entering a number. For
example, when I enter the E1 into a cell, I'd like the cell to populate with "Excellent scores". If I enter E2, the cell should populate with "Additional training required". The list goes on and on. Can someone please let me know how I can do this? Thank you in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populating excel fields
What you're describing is sort of a "named formula", since you want to
display the text in the same cell you enter the "number code". If you're willing to type, for example: =e1_ in a cell to display your text, it can be accomplished. XL adds the underscore because "E1" is reserved, since it's the name of a cell. If you used: one two three OR Tom Dick Harry all you'd need to type would be the equal sign ( = ) in front of the "code". Try this: Make a datalist, with your "Codes" in say Y1 to Y10, and your text in Z1 to Z10. Select Y1 to Z10, and from the Menu Bar, <Insert <Name <Create Make sure *only* "Left Column" is checked, then <OK. Now, go to, <insert <Name <Define And see if XL accepted your names as you typed them, or were there any changes. In *any* cell, type = then any name from the *accepted* name list, and you'll see the text displayed for that "code". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ddotsyl" wrote in message ... I'd like to be able to auto-populate a cell by entering a number. For example, when I enter the E1 into a cell, I'd like the cell to populate with "Excellent scores". If I enter E2, the cell should populate with "Additional training required". The list goes on and on. Can someone please let me know how I can do this? Thank you in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populating excel fields
This is exactly what I needed! Thank you!!
"RagDyer" wrote: What you're describing is sort of a "named formula", since you want to display the text in the same cell you enter the "number code". If you're willing to type, for example: =e1_ in a cell to display your text, it can be accomplished. XL adds the underscore because "E1" is reserved, since it's the name of a cell. If you used: one two three OR Tom Dick Harry all you'd need to type would be the equal sign ( = ) in front of the "code". Try this: Make a datalist, with your "Codes" in say Y1 to Y10, and your text in Z1 to Z10. Select Y1 to Z10, and from the Menu Bar, <Insert <Name <Create Make sure *only* "Left Column" is checked, then <OK. Now, go to, <insert <Name <Define And see if XL accepted your names as you typed them, or were there any changes. In *any* cell, type = then any name from the *accepted* name list, and you'll see the text displayed for that "code". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ddotsyl" wrote in message ... I'd like to be able to auto-populate a cell by entering a number. For example, when I enter the E1 into a cell, I'd like the cell to populate with "Excellent scores". If I enter E2, the cell should populate with "Additional training required". The list goes on and on. Can someone please let me know how I can do this? Thank you in advance! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populating excel fields
You're welcome, and thank you for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ddotsyl" wrote in message ... This is exactly what I needed! Thank you!! "RagDyer" wrote: What you're describing is sort of a "named formula", since you want to display the text in the same cell you enter the "number code". If you're willing to type, for example: =e1_ in a cell to display your text, it can be accomplished. XL adds the underscore because "E1" is reserved, since it's the name of a cell. If you used: one two three OR Tom Dick Harry all you'd need to type would be the equal sign ( = ) in front of the "code". Try this: Make a datalist, with your "Codes" in say Y1 to Y10, and your text in Z1 to Z10. Select Y1 to Z10, and from the Menu Bar, <Insert <Name <Create Make sure *only* "Left Column" is checked, then <OK. Now, go to, <insert <Name <Define And see if XL accepted your names as you typed them, or were there any changes. In *any* cell, type = then any name from the *accepted* name list, and you'll see the text displayed for that "code". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ddotsyl" wrote in message ... I'd like to be able to auto-populate a cell by entering a number. For example, when I enter the E1 into a cell, I'd like the cell to populate with "Excellent scores". If I enter E2, the cell should populate with "Additional training required". The list goes on and on. Can someone please let me know how I can do this? Thank you in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically populating fields in excel | Excel Worksheet Functions | |||
Populating multiple fields from existing data | Excel Discussion (Misc queries) | |||
Populating sequentialcombo's or fields | Excel Worksheet Functions | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Auto populating fields | Excel Worksheet Functions |