M
mike allen
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
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