Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using codes to input saved info into a cell?
I'm pretty uneducated on excel but am trying to develop a master list of
coded infomation that I can simply type a "code number or item number" which will then input the saved info for that "item number" into the adjoining cell, along with a cost associated with that item number. Where do I save this "master list" of info so that when I begin to type the "code" or even begin typing info into a cell, my "master list" of info will auto fill, or give me choices of saved info that i'd like to have put in that cell. Please help. Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using codes to input saved info into a cell?
Hi Chris I have just put a file up for you at:-
http://www.pierrefondes.com/ Check out item number 27 (at the top of my home page at the moment). If you input any of the numbers 1, 2, 3, or 4 in cells A 2 to A 5 you will get the cost appearing automatically in cells C 2 to C 5. I think that this gives you most of what you want but not your last part. If my comments have helped please hit Yes. Thanks. "chris1982" wrote: I'm pretty uneducated on excel but am trying to develop a master list of coded infomation that I can simply type a "code number or item number" which will then input the saved info for that "item number" into the adjoining cell, along with a cost associated with that item number. Where do I save this "master list" of info so that when I begin to type the "code" or even begin typing info into a cell, my "master list" of info will auto fill, or give me choices of saved info that i'd like to have put in that cell. Please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I input codes? | Excel Discussion (Misc queries) | |||
Replacing Input Box in Macro with Info Picked Up from Active Cell? | Excel Discussion (Misc queries) | |||
How do I get a cell to change size with the info I input? | New Users to Excel | |||
Fill a seperate cell with info depending on the input in another c | Excel Discussion (Misc queries) | |||
zip codes not being saved as text in CSV format | Excel Discussion (Misc queries) |