Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
odd question
not sure what you list this subject as. sorry.
say you have, in a simple spreadsheet: cells A1="mary" A2="bill" A3="sally" in cell A4, if you type "b", the name "bill" will pop up as you type. this just shows that "bill" is the only possible duplication that starts w/ "b". ok. what i would like is to type in another cell, even another sheet, and have this feature reference cells A1:A3. ex: in cell G2, if i type "b", nothing will happen, but i would like to format that cell, or cells, to have "bill" pop up. is this possible? sorry for the oddball question. thanks, mike allen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
odd question
Press f1 and checkout "Create a list"?
That may assist in your question which is not as oddball as you think! Cheers Jp "mike allen" wrote in message ... not sure what you list this subject as. sorry. say you have, in a simple spreadsheet: cells A1="mary" A2="bill" A3="sally" in cell A4, if you type "b", the name "bill" will pop up as you type. this just shows that "bill" is the only possible duplication that starts w/ "b". ok. what i would like is to type in another cell, even another sheet, and have this feature reference cells A1:A3. ex: in cell G2, if i type "b", nothing will happen, but i would like to format that cell, or cells, to have "bill" pop up. is this possible? sorry for the oddball question. thanks, mike allen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
sum if question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |