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

[syar]

Syar Bhai Asslamo-Alaikum
Syar Bhai mein saudi Arab Travel Agnecy Mein job karta hoon Aur Leadger Ka kaam Aur Tickting Ki details waigaira sab mein handel krta hoon Aur ye sab mein Manual karta hoon matlab k leadger book mein mein chahta hoon kuch Computer mein Aisa Formate ya koi Software ho ju mera kaam Easy ho jay Excel ya kuch bhi
mein Payment bhi kar skta hoon Lakin kaam acha ho
plz zaroor replay dijye ga plz

Salam,
Jesa haseeb sb n aap ko mashwara deya ha, aap jese manual register m.entry krte hain, wese he excel m head wise columns bana lain. phr aap ko formula lagana ho ya help drkR ho tu koi bhe is forum p ya aap k ofice m help kr dega. aur agar aap software ya kisi sa paid hp chahtehain tu kisi softwAre devloper sa help la lain. wo aap ki bht hlp kr de ga. volunteer help chaheye ho tu you are welcome , koi bhe is forum p help kr de ga.
Regards

[syar]

Assalam-o-alaikum
SYAR Bhai,
apne jo method btaya tha usay mai ne apply to kar dia per us ke working method k asal me yeh formula hai kia, smjh nahi paya, Ap ne explain kar dia to bht acha laga kio k pehle mai mai es formulay ko bas isi sheet pe apply kar skta tha, magar ab isi formula ko mai kahi bhi use kar sakta hoon, Thanx a lot... Wish You A Good Luck, Wassalam :JC_THANKYOU:

Khushe hoe k aap ka masla hal ho gaya ha. yahe formula aap ko row ki last value bhe return kre ga, aap srf column ki jaga row ki range lain tu. yane. A1:a50
Regards

[farhan_A]

bahot achah ALLAH aap ko ajar dy

[Mahtaab]

Dear ITD Members


Kia Excel me text ko animate kia ja sakta hai, yani agar column ka size ek limit me ho magar us column me jo text ho wo long ho to kia usay animate kia jasakta hai, ta k bina cell ko selct kiye wo tmam text hamain show ho jaye like news line in bottom of screen in News Channels....

[syar]

Dear ITD Members


Kia Excel me text ko animate kia ja sakta hai, yani agar column ka size ek limit me ho magar us column me jo text ho wo long ho to kia usay animate kia jasakta hai, ta k bina cell ko selct kiye wo tmam text hamain show ho jaye like news line in bottom of screen in News Channels....

Nahee asa koi function nahee ha. Aap asa VBA k through kr sakte hain, lkn jahan tak m aap ki bat samjha hon, aap ise pore column ya rows p apply krna chahenge, Jis k side effects hain, yane aap ka computer slow ho jae ga, memory bohat zyada use ho gi. and in worse case aap ka system crash bhe kr sakta ha. is leye m ya recommend nahee kronga. agar aik ya do cell p lagana ho for fun to thek ha. otherwise , recommend nahee kronga
regards

[Mahtaab]

:bismellah::
:

Nahee asa koi function nahee ha. Aap asa VBA k through kr sakte hain, lkn jahan tak m aap ki bat samjha hon, aap ise pore column ya rows p apply krna chahenge, Jis k side effects hain, yane aap ka computer slow ho jae ga, memory bohat zyada use ho gi. and in worse case aap ka system crash bhe kr sakta ha. is leye m ya recommend nahee kronga. agar aik ya do cell p lagana ho for fun to thek ha. otherwise , recommend nahee kronga
regards

Mujhay Tmam Row Ya column pe nahi just 4 column jo merge kiye gaye hain aur ab aik hi column consider kiye jatay hain, un pe apply karna hai, VB Script Day Dijiye Please and USage ka method bhi.. m waiting

[Mahtaab]

[sadiq tanoli]

MASHA ALLAH BUHT ACHHI KOSHISH HAI,
1)MUJHEY YEH POOCHNA HAI K EXCELL FILE MAIN CLIENTS K BESHUMAR NAMES HOTEY HAIN AKSAR DOUBLE ENTRY HO JATI HAI JO MISTAKE HE HAI, KOI AISA TARIQA BATA DEYN K JAB AIK HE NAME REPEAT HO RAHA HO TO SYSTEM (EXCEL) INFORM KAR DEY
2) EXCEL MAIN URDU KIS TARH TYPE KI JATI HAI
THANKS
SADIQ TANOLI

[syar]

:bismellah::
:



Mujhay Tmam Row Ya column pe nahi just 4 column jo merge kiye gaye hain aur ab aik hi column consider kiye jatay hain, un pe apply karna hai, VB Script Day Dijiye Please and USage ka method bhi.. m waiting

Aap apne question ko ask an expert m post karian shayad koi VB ko janne wala aap ko code kr k de sake. M n kabhe try nahee ki is p. is leye sorry

regards,

[syar]

Aap ka formula drust ha. Masla sirf itna ha k aap n jo formula lagaya ha use hm excel m relative reference ya ranges kahte hain. Yane Jab aap ise copy krte hain tu aap notice karain ge k ranges change ho gain hain. for example aap ka formula ha =VLOOKUP(H6, party!B223,2,FALSE), lkn jap aap ise nechy copy kriange tu ya =VLOOKUP(H7, party!B324,2,FALSE) ho gaya ha. yane b2 sa b3 ho gaya ha. Ya excel automatic krta ha q k is k kafi faida hain aur bht si jagha p ya kam krta ha. lkn jap aap ko kisi fixed range he ko bar bar copy krna pre tu ise hm absolute reference kahte hain. yane formula copy krte hoe range change na ho. Is maqsad k leye formula m hm range k sath DOLLAR ka sign use krte hain. tu aap ka formula ya ho ga

=VLOOKUP(H6, party!$B$2:$D$23,2,FALSE)

Ab aap daikhen ga formula m dono trah ki references use ki gai hain. AAp ko column H ki value Party ki sheet m Column B sa match krna ha, tu is k leye COLUMN B ko fixed raka gaya ha jab k column H k reference ko relative rakha ha yani copy krne p reference change hota rahe.

hope you will understand. AAp thoda practice karainge tu aap ko smjh m ajae ga.

regards,

[syar]

MASHA ALLAH BUHT ACHHI KOSHISH HAI,
1)MUJHEY YEH POOCHNA HAI K EXCELL FILE MAIN CLIENTS K BESHUMAR NAMES HOTEY HAIN AKSAR DOUBLE ENTRY HO JATI HAI JO MISTAKE HE HAI, KOI AISA TARIQA BATA DEYN K JAB AIK HE NAME REPEAT HO RAHA HO TO SYSTEM (EXCEL) INFORM KAR DEY
2) EXCEL MAIN URDU KIS TARH TYPE KI JATI HAI
THANKS
SADIQ TANOLI

Walikum Salam,
Brother aap k dono masle ka hal ise thread m ha aap ise start sa study krain tu aap ko kafi kuch sekhne ko mile ga. Aap ka probelm No.1 conditional formatting sa solve ho ga, jis ka method ise thread m kai jaga ha. aur urdu lekhne ka solution be ha.

regards

[waqasbhutta]

Aslaam o Alikum Faisal bai

Ap nany Excel ki jo help line start ki hai. Excellent work.

Ap nay jo Excel ka Micro ka video tutorial upload kia hai wo play keun nahee ho raha.