Excel Help Line مائیکرو سافٹ ایکسل ہیلپ لائن سینٹر

[syar]

Assalam o alikum Syar Bhai

ya jo code aap ny dia ha ma ny try kia lakin ya kam nae kr raha save as ka option b ata ha or file save b ho rahi ha lakin us ky under amendment nae ho rahi. App zara try kraen

Walikum Salam,

Kya aap apni file as it is yahan share kar sakte hain. aap apna data delete kar dain mujhy sirf coding dekhne ha k kahan p lekhe ha. Ya codig thisworkbook m lekhne ha aur jab excel open karte hon tu Enable/Disable MACRO ka notice aata ho ga jo k aap na enable karna ha.
2nd kya aap na apni sheet Macro Enabled workbook save ki ha k nahee. agar nahee ki ha tu aap ki coding kam nahee kare g.

Ho sake tu apni workbook share kar dain k m deekh sakon.
regards,

[sohail1966]

Syar bhai mein yeh aik file upload kar rha hoon, mein chah rha tha ke sheet one par sirf Employee No. likhoon aur serial No. 1 se lekar 6 tak baqi entries khood ba khood ho jain.
Bohat bohat shukria.

[syar]

Aap na bohat zyada merge cell use keye hain. in ko khatam karain q k jab aap kahte hain k m employee number lekhon tu baqi automatic aa jae. Tu jab aap n employee ka cell he merge kar deya ha tu aap employee ka number lekhain ga tu excel is pore cell ko as a text le ga. tu aap name, job title etc m formula kahan lagain ge. aur formula value kahan sa read kare ga. Hope you will resolve this problem 1st. wese tu m bhe kar k de sakta hon lekan aap khod try karain.

2nd jab aap merge cell ka masla solve kar lain tu phir VLOOKUP ka formula use karain. aap ka masla hal ho jae ga.

agar aap sa na ho tu phir bataye ga. aaj aap bhe thodi practice kar k dekhain.


regards

[sohail1966]

Bohat Bohat shukria Syar bhai mein koshish karta hoon..

[sohail1966]

Syar bhai mein yeh file dobara attach kar rha hoo us ko modify karney ke bad aur meine us mein VLOOKUP ka formula bhi lgani ki koshish bhi ki thi lekin kamyab na ho ska please help..

[syar]

Attached file m vlookup k formula ko study kejeya ga.
aur excel ki builtin help m bhe vlookup ko use karna k method read kejeya ga.

regards

[sohail1966]

Bohat bohat shukria Syar bhai, Allah ap ko mzeed taraqi dein aur Ramzan ke ba barkat maheenay mein Allah ap par khsoosi rehmat karain.
Amin.

[sohail1966]

Syar Bhai aik cheez ke mtalaq poochna tha ke maslan hmaray pass colomn A mein captial letters hoan aur us par ham proper ki command laga kar us ko Mix formate yani small aur capital form mein likhna chahey aur ussi col mian value lagay.
yani
a1=ASLAM
a2=AKBAR
a3=ANWAR
aur isi col main formula lagaye to
Aslam
Akbar waghaira waghaira ajaye.
mein ne yeh formula laghia tha a1 mein
=Proper(ASLAM)
Lekin wo error deta hay.

[syar]

maslan hmaray pass colomn A mein captial letters hoan aur us par ham proper ki command laga kar us ko Mix formate yani small aur capital form mein likhna chahey aur ussi col mian value lagay.
yani
a1=ASLAM
a2=AKBAR
a3=ANWAR
aur isi col main formula lagaye to
Aslam
Akbar waghaira waghaira ajaye.
mein ne yeh formula laghia tha a1 mein
=Proper(ASLAM)
Lekin wo error deta hay.

jab aap formula m direct text use karain tu us ki sath "" lazmi use karain. aap ka correct formula ho ga

=proper("ASLAM")

lekan agar aap sab k sath ya karna chahte hain tu ap k leye mushkil ho gi q k aap ko text har formula m manual lekhna ho ga. yani akbar, aslam etc k leye har cell m alag alag. I have a suggestion agar aap follow karna chaho tu.

I assume k column A m aap k tamam entries mujood hain. aur A1 aap ka heading column ha. aur a2 sa aap ka name start hote hain. aap aik temporary column B insert karain aur B2 m ye formula lagain aur jahan tak aap chahte hain drag kar lain.

=proper(a2)

Ab aap ya karian k column B ko select karain aur copy kar lain. Phir yahen par rahte hue Paste special ko select karain aur us m sa "VALUE"
par click kar lain. ab aap ka column b ki tamam entries formula ki jagha text m change ho jae gi. aur aap column A ko delete kar dain q k is ki zarorat nahee rahe gi.

regards

[sohail1966]

Syar Bhai bohat bohat shukria.

[syar]

Activity Plan

[Nabeel Jutt]

good Post .... Keep It up