Excel problem pls help me

[shahleopak]

ALL MEMBER OF IT DUNYA PLS KOI MERI HELP KARE ME NE PEHLE B EK THREAD ME POCHA THA AB DOBARA POCH RHA HON
ME NE DROP DOWN LIST BNANI HA PLS KOI MJH KO BTAYE K KIS TRHA BNATE HEN ME CHATA HON K JB KOI NAME YA CLIENT A/C SELECT KARO TO SIRF US KI DETAIL AJAYE BAQI KISI KI NA HO PLS KOI BTAYE K KIS TRHA BNATE HEN DROP DOWN LIST AGR HO SKE TO PLS SAMPLE BNA K SEND KR DEN MEHRBANI HO GE

LOOK

[shahleopak]

any member pls help me

[Lesson4me]

file attach ke hay check karkay batay k is tarha ki aproch chahehay.
ya sirf fist name dropdown may select karnay per sub data a jae.

Ya drop down list ki kuch limitatio hote ha. kia user form acceptable hoga.

Request IP Address Record na karay.

[shahleopak]

thnx jnab lekin ap ne jo sheet bnaye ha us me cell ko select kro to wo show krwata ha bottun button b show ho or me jo adres, name , A/C add kro wo sirf me he del ya change kr skon koi dosra nhi or agr me A/C me se koi b A/C select kro to us ki detail ajaye yani name, cel no Adres etc jo b add kro pls ap dono method bta den ap ki mehrbani ho ge
button show hona chaye
or ye b btana jo bnaye ha lekin is ko user change ya del na kr ske

[Lesson4me]

main aap ki baat nahee samjha.
1. Aap drop down list chahte ho ya user form. Kiyon k drop down sirf data show kar raha ha sheet no.2 se jis ko koi bhee edit kar sakta ha. Protect karne k leye aap ko sheet protect karna hoge.
2. Button approach require Macro(VBA) which is not dependent on Drop down.
3.AAp explain karo k kia aap ye chahte ho k kise bhee(adrs,cell,accnt,name) k button par click karain tu kia sirf wohe record show ho ya ka sare ki sare field.

please explain eah point separate.

regards

[shahleopak]

jnab me agr name select kro to wo name ki detail de yani A/c no, adres Cell no etc jo Add kro jaisay ap ne name me show kia ha a b c agr a ko select kro to a k sath A/c, Adres, Cel no b show ho jaye
ab to ap samajh gaye hen