Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Just type the word
Hi!
Is it possible? For example, lets say in A2 of sheet #1 the data entered in the cell is "ABC Computer Supplies, 123 Main Street, Akron Ohio 21657." Now if I begin typing "ABC" in Sheet 2 that data will automaticly appear and I simply have to hit enter and the data is there Because one of my friend told me that it is possible But unfortunately he also dont know how. Thanks In Advance Hardeep Kanwar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Just type the word
Possible......yes.
Easy..........not without some help from a combobox. See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlDataVal10.html You can ignore the DV part if you wish and just create a combobox. Gord Dibben MS Excel MVP On Sun, 11 May 2008 08:22:42 -0700 (PDT), pai wrote: Hi! Is it possible? For example, lets say in A2 of sheet #1 the data entered in the cell is "ABC Computer Supplies, 123 Main Street, Akron Ohio 21657." Now if I begin typing "ABC" in Sheet 2 that data will automaticly appear and I simply have to hit enter and the data is there Because one of my friend told me that it is possible But unfortunately he also dont know how. Thanks In Advance Hardeep Kanwar |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Just type the word
Dear sir
I cannot understand. I mean to say just type the word in another sheet and the whole information display automatically. But i cannot see the result that i want Thanks Hardeep kanwar "Gord Dibben" wrote: Possible......yes. Easy..........not without some help from a combobox. See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlDataVal10.html You can ignore the DV part if you wish and just create a combobox. Gord Dibben MS Excel MVP On Sun, 11 May 2008 08:22:42 -0700 (PDT), pai wrote: Hi! Is it possible? For example, lets say in A2 of sheet #1 the data entered in the cell is "ABC Computer Supplies, 123 Main Street, Akron Ohio 21657." Now if I begin typing "ABC" in Sheet 2 that data will automaticly appear and I simply have to hit enter and the data is there Because one of my friend told me that it is possible But unfortunately he also dont know how. Thanks In Advance Hardeep Kanwar |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Just type the word
Autocomplete for cells works only within one sheet and only when data is
contiguous in a column. To do what you want requires the ComboBox method. Follow Debra's instructions for creating a combobox with a list of words. Autocomplete will work in that combobox. Gord On Mon, 12 May 2008 09:43:01 -0700, pai wrote: Dear sir I cannot understand. I mean to say just type the word in another sheet and the whole information display automatically. But i cannot see the result that i want Thanks Hardeep kanwar "Gord Dibben" wrote: Possible......yes. Easy..........not without some help from a combobox. See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlDataVal10.html You can ignore the DV part if you wish and just create a combobox. Gord Dibben MS Excel MVP On Sun, 11 May 2008 08:22:42 -0700 (PDT), pai wrote: Hi! Is it possible? For example, lets say in A2 of sheet #1 the data entered in the cell is "ABC Computer Supplies, 123 Main Street, Akron Ohio 21657." Now if I begin typing "ABC" in Sheet 2 that data will automaticly appear and I simply have to hit enter and the data is there Because one of my friend told me that it is possible But unfortunately he also dont know how. Thanks In Advance Hardeep Kanwar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I type a word in a cell, tab out and it changes | New Users to Excel | |||
I would like to type one word on top of the other in Excel | New Users to Excel | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) |