Excel problem pls help me urgently

[shahleopak]

ALL MEMBERS OF IT DUNYA
ME NE EXCEL ME EK ACOUNT INFORMATION SHEET BNANI HA ME NE FILTER USE KIA HA PLS KOI MJH KO BTA SKTA HA ME CHATA HO K JB ME NAME ME SE KOI B NAME SELECT KRO TO JO NAME SELECT KIA HO US KI DETAIL AJAYE YANI US KA A/C No, CELL No, Adres ETC ALL INFO
PLS KOI MJH KO BTAYE YA FILTER K ELAWA KOI OR METHOD HA TO PLS WO BTA DEN MJH KO SHEET BNANI HA COMPANY KI PLS URGENTLY HELP ME
SCREEN SHOT DEKH LEN NAME KI JAGA JO NAME DIYE JAYEN WO SIRF NAME BOX ME SHOW HON COLUMN ME NHI
PLS HELP ME

[syar]

salam::

kia aap drop down list chahte hain k wo name k dropdown per dependent ho k name ki dropdown m aap name select karain aur wo baqi dropdown m aap k result show karain.

Ya formula chahte hain jaise (inde/match, vlookup).
please reply

regards

[Zaara]

My aj is per kaam karti hun bhai then tell you

liken kia aap aisy chahty hain k name show hun jesy Zara aur Amna likhy show ho rahy hain?

[shahleopak]

Zara jee Thnx for rply me aisay he chata hon list me show hon jb list select kren lekin samnay show na hon kia samaj gaye ahen ap mera kehne ka matlab
list me show hon sheet pe na show ho jb koi name select karen to us name ki detail show ho jaye pls help me

[syar]

ye batain k name k elawa bhe aap baqi field box he ma chahte hain ya box k elawa bhe ajain to koi problem nahee.

[shahleopak]

jnab me chata hon k list box hr cell me ho jb me A/c no ya name select kro to wo mjh ko us ki detail show kraye jaisa k me ne IT DUNYA me excel me QURAN-e PAK likha hwa dkha ha us me ye htha k jis surat ko select kro ge wohi show ho jaye ge ya surat no ko select kro wo b us surat ko show krta ha

[syar]

Bhai solution aap ko sham ko mil gae ga. inshallah

[Nadeem Ahmed Kh]

tum hamesha confusing mai sawal karte ho kabhi clear nahi hota tumhara sawal, janab, mafi chahuga magar what u want actually? not clear

[shahleopak]

jnab ap screen shot dekhen or me ne example de ha na k me ne IT DUNYA me ek excel ki file dekhi the us me QURAN-e-PAK likha howa tha us file me ye tha k jis sorat ko select kro wo sorat show ho jaye ge jnab meri post all dobara prho samaj ajaye ge k me kia chata ho
pls koi help kare meri abi tk kisi ne nhi ke bs pochte rhte ho jnab detail all bta de ha

[syar]

Bhai jan aap jis excel file ki bat karte ho "Excel in Quran" by Mubashir aziz . Is file m simple filter istial keya howa ha. Aur aap jo chchte ho wo ya tu user form k zarye ho sakta ha Ya drop down list k zarye. User form par thoda time lagta ha kiyon k coding thodi mushkil hote ha. Jab k drop down list aap khod bana sakte hain.

aik tareeqa drop down banana simple hote ha jab k dosra mushkil hota ha. Dono data validation ko istimal karte huwe bante hain.

Agar aap apne problem k quick solution chahte hain tu filhal aap simple,vlookup, lookup,index/match etc k istimal kar k apna masla hal kar lain. dosri sorat m aap intizar karo.

regards

[shahleopak]

Syar Brother chlo ap mjh ko simple list ka he bta do jis trha QURAN-E-PAK excel me ha koi b Sorat ko select kro wo sorat ajati ha isi trha me b yehi chata hon koi b name ya A/c no select kro us ki detail ajaye pls ap mjo ko detail se btao or simple list me koi mere elawa changing na kr ske wo protection method b bta
or Index wala method b btana mehrbani ho ge Vlookup wal

pls ho ske to sample sheet bna kr mjh ko email kr den ya PM kr den
Email Id: shahleopak***********
waiting.................

[syar]

Sorry for my late reply. Main Eid ki vacation par tha.


Sample Data Sheet 2 par ha. Aur Formula Sheet 1 per apply keye gae hain.

Agar aap vlookup aur index/match ka drust istimal seekh lain tu aap ko dropdown list ya
User form ki zaroorat nahee pare ge.



Is k elaawa sheet 2 per main ne filter lagaya howa ha. Is m aap jis cell ko bhee muntakhib karain ge baqi data auto select ho gaye ga. Filter lagane ke leye pehle aap apne table ki kisi bhee cell me cursor ko lain aur phir data k tab m ja kar filter par clik karain. Filter apply ho gaey ga.

Mere recomendation ye hoge k aap "Name" ko base banane k bajae A/c No ko base banae kiyon k Name tu aik se zayad duplicate ho sakte hain. Leekan aap apni situation ko behter samajhte hain.



INdex/match aur vlookup (Normal Case) m jo function istimal huwe hain wo genrally istimal hone wale hain. Leekan Vlookup k doosra function jo istimal huwa ha it is special to avoid enter index_number manually


AAp in functin ko deekahin next time m aap ko drop down list banane k method bataon ga. Leekan aap in function se familiar nahee tu please spend sometime on it and if any trouble plaease let me know.

Agar ho sake tu apni file share kar dain. Name aur a/c no change kar lain mujhe sirf ranges check karne hain.


Thanks and regards.