Excel Help need.!

[ihtesham_ulfat]

Dear All,
Kesy hen aap..
Men ny excel men aik llist bnai, data validation ko use kerty hoy. jesa k ap pic men dekh rhy hen. ab men yih chah raha hon k jesy men isy list ki Alt+Down arrow key press kr k open keron to list men moujod item k ksi bhi option first leter press keron to selection us option py chli jaye aur enter krny py wo cell men aa jay.....
jo k is trah short cut nai ho raha ... agr hndrer options hongi to mujhy last option py jany k ly 99 bar down errow key pres krna pryga.!!! jo k bahut time losing hia na...!! to plz koi bnda bta dy yih.. k men kesy is list ko handle kr skta hon.
Ap k early response ka wait.

Regards

[yasir niazi2k2]

cntrl+down arrow press karo last par chaly jaogy

[ihtesham_ulfat]

cntrl+down arrow press karo last par chaly jaogy

men ny list men move krna hai na k excel sheet men...
list men men ny last waly py nai jana...
mera mtlb hai k agr

100 items hen list men

to men jo letter pres kron to wo item list men sy select ho jay jiska first letter wohi ho ji men ny pres kia ho.

[yasir niazi2k2]

ok here you go brother

https://blogs.princeton.edu/hrc/2011...ent_lists.html


http://office.microsoft.com/en-us/ex...001217036.aspx

[ihtesham_ulfat]

Shaid men apko smjha nai paya.... ya ap smjh nai paye....
Bahar hal.... thank u...!!!

.....

koi aur hai yahan jisy mera yih msla smjh aya ho???

[Derwaish]

brother normally iss k ley ek formula use hota hai i think so....
any way aap yeh link check kareey

link How to find data in an Excel table

Suppose your data is from A1 to A100 or onward ..... then in B1 copy this formula and drag it down ....

=IF(ISERROR(SEARCH("*apple*",A1,1)),"","A ")

[ihtesham_ulfat]

Yih aur hai....

meri requirement ko smjhny ki koshish kren...
men ny aik list bnai validation k trogh, ab list men supose (one, two, three............ hundred) tk listd items hen. ab men agr list waly cell me jata ho aur jesy hi koi letter key board sy press kron to list men moujod items me sy woh item select ho jay jiska pahla leter press howa ho......

[ihtesham_ulfat]

supose k men key board sy "H" press krta hon to list me last item hai "Hundred" to wo select ho jaye.... bs... itni c bat hia.....!!!

[Teeayk]

You are right. You will have to press down arrow key 49 times in order to come to number 50 (in a list of numbers, for example.) you should press 'F' and it should first go to Five, Fifteen, and then on Fifty.

I think I understand your problem but can't seem to find the solution. In Visual Basic I remember using "&" before the word that you want to use as hot key (Alt + Key)... anyways, I will keep searching for it and let you know once I find solution Try making /searching macro for this.

[ihtesham_ulfat]

You are right. You will have to press down arrow key 49 times in order to come to number 50 (in a list of numbers, for example.) you should press 'F' and it should first go to Five, Fifteen, and then on Fifty.

I think I understand your problem but can't seem to find the solution. In Visual Basic I remember using "&" before the word that you want to use as hot key (Alt + Key)... anyways, I will keep searching for it and let you know once I find solution Try making /searching macro for this.

Yeah you are right..... ab bilkul sahi smjhy hen.,.... is k ly koi VBA micro hi use hoga... phly mujhy bhi pta tha..... mgr badluck k bhol gia hon, to is ley kkhpna pr raha hai... han agr aisa bhi aik option ho ga... k VBA ki coding bhi na krni pry aur yih kam bhi ho jaye....!! anyway ap bhi serch kren men bhi kr raha hon... but ap share kejyga... men intezar kr raha hon..

[syar]

Salam;;

2 method hain. aik to vba ka dosara desi totka ha jo k tricky ha.
jahan par ap na drop down list banani ha us sa oper ka cell me apna tamam list copy kar dain aur un cells ko hide kar dain ap ka masla hal ho jae ga.
for example
agar ap ki list m 10 name hain tu aap a1 se a10 tak name lekhai aur unko hide kar dian. jab ka drop down a11 se bana lain. ap ka masla bhe hal ho jae ga aur kisi ko pata bhe nahee chale ga.
agar ya mumkin na ho tu bataye ga phir ap ko vba ka batata ho
regards

[ihtesham_ulfat]

Salam;;

2 method hain. aik to vba ka dosara desi totka ha jo k tricky ha.
jahan par ap na drop down list banani ha us sa oper ka cell me apna tamam list copy kar dain aur un cells ko hide kar dain ap ka masla hal ho jae ga.
for example
agar ap ki list m 10 name hain tu aap a1 se a10 tak name lekhai aur unko hide kar dian. jab ka drop down a11 se bana lain. ap ka masla bhe hal ho jae ga aur kisi ko pata bhe nahee chale ga.
agar ya mumkin na ho tu bataye ga phir ap ko vba ka batata ho
regards

Yih trick mujhy to aa jati hai.. men yih trick nai krna chah raha.,..
Plz aap VBA wala bta den....