Auto data entry

[ataur rahman rony]

Hi all,

In sheet-1 , B Column i have lots of name.Suppose HP,DELL,APPLE. when i write just App it will auto show me APPLE. But in sheet-2,3,4 it does not show me the name. I have to write it or use data validation for entry.

Is there is any Excel option, that sheet-2,3,4 show me the same NAME like sheet-1, when i entry some word.

 

[Claus Busch]

Hi Ataur,

Am Mon, 29 Sep 2014 05:53:27 -0700 (PDT) schrieb ataur rahman rony:

In sheet-1 , B Column i have lots of name.Suppose HP,DELL,APPLE. when i write just App it will auto show me APPLE. But in sheet-2,3,4 it does not show me the name. I have to write it or use data validation for entry.

if you have written the values one time into the column the values will
be shown while writing.
That feature works in columns if you don't have empty cells in it. With
empty cells you must start new.


Regards
Claus B.

 

[ataur rahman rony]

Hi Ataur,



Am Mon, 29 Sep 2014 05:53:27 -0700 (PDT) schrieb ataur rahman rony:






if you have written the values one time into the column the values will

be shown while writing.

That feature works in columns if you don't have empty cells in it. With

empty cells you must start new.





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Thnx Claus.