Excel Problem Urgently Help

[shahleopak]

1: ALL MEMBER OF IT DUNYA ME NE EXCEL ME ACOUNT SHEET BNANI HA MERI COMPANY ME 1000 CLIENT HEN ME CHATA HON K AISI SHEET BNAO K ME SIRF ACOUNT NO LIKHO TO US ACOUNT KI DETAIL DE DE YANI US KA ADRES CELL NO ETC KIA KOI MJH KO BTA SKTA HA K ME KIS TRHA BNAO ME NE SUNA HA K DROPDOWN BUTTON SE BAN SKTA HA LEKIN KAISAY?

2:
DOSTO ME NE EXCEL ME COMPANY LEDGER BNAYA HA LEKIN EK PROBLEM HA ME CHATA HON K US ME BLANK JAGA 0 NA LIKHA AYE BLANK HO NICHAY DEKHEN
PLS HELP ME URGENTLY WAITING........

[Zaara]

1: ALL MEMBER OF IT DUNYA ME NE EXCEL ME ACOUNT SHEET BNANI HA MERI COMPANY ME 1000 CLIENT HEN ME CHATA HON K AISI SHEET BNAO K ME SIRF ACOUNT NO LIKHO TO US ACOUNT KI DETAIL DE DE YANI US KA ADRES CELL NO ETC KIA KOI MJH KO BTA SKTA HA K ME KIS TRHA BNAO ME NE SUNA HA K DROPDOWN BUTTON SE BAN SKTA HA LEKIN KAISAY?

2:
DOSTO ME NE EXCEL ME COMPANY LEDGER BNAYA HA LEKIN EK PROBLEM HA ME CHATA HON K US ME BLANK JAGA 0 NA LIKHA AYE BLANK HO NICHAY DEKHEN
PLS HELP ME URGENTLY WAITING........

Bhai first bwaly ka answer why don’t you use Access for this Purpose? It is easy to find any data or record.

Secondly bhai aapki samajh nahi aai k what do you want to say (kia 0 na hu aur wo jaga blank ho) is it Bhai?

[shahleopak]

Pls Ap Mjh Ko Access K Through Btaa Den Or Ho Ske To Excel K Through B Bta Den
Or Ye Sheet Check Kren Me Ne Db/cr Ka Formula Lgaya Ha Jahan Amount Nhi Hoti Waha 0 Likha Ata Ha Me Jb Print Nikalte Hen To 0 Sath Hota Ha Me Chata Hon K Jahan Amount Nhi Ati Us Jaga 0 Na Likha Ho Pls Help Me

[Zaara]

Its fine i have checked yahan 0 nahi aaraha in Print out

[shahleopak]

Zaara Ge Jb Me Print Leta Hon To 0 Sath Ata Ha Or Pehlay Swal Ka B Jwab Den Pls Excel Se Method Btayen Or Access Se B Mehrbani Ho Ge
Waiting

[shahleopak]

Zara Pls Help Me I M Waiting
Any One Too

[shahleopak]

all members pls help me
pls help me

[syar]

Please check the attached file if this solved your problem for hiding zeros.

2n prolem k leye aap attached file m custome detail,solution1 and solution 2 ki sheets deekhen kia aap ko is ki zaroorat ha.

Agar koi kami ho to zaroor batain.

Thanks & regards

[syar]

2nd and the easiest option to hide zeros.

Apna sara data select karain( except last column ki jahan minus value hain).
Format cell me ja kar custom format select karain aur
0;-0;;@

paste kar dain. App ke tamam select karda range main agar app 0 enter karain ya formula 0 return kara hide ho jae ga.(see attached file)

thanks and regards

[shahleopak]

Thnx all member meri 2nd problem solve kr de lekin ist problem me me chata hon k Dropdown Button se jo bnate hen pls wo method btao yani home page khali ho me jo b acount no likhon us ki detail aye pls any body help me

ALL MEMBER OF IT DUNYA ME NE EXCEL ME ACOUNT SHEET BNANI HA MERI COMPANY ME 1000 CLIENT HEN ME CHATA HON K AISI SHEET BNAO K ME SIRF ACOUNT NO LIKHO TO US ACOUNT KI DETAIL DE DE YANI US KA ADRES CELL NO ETC KIA KOI MJH KO BTA SKTA HA K ME KIS TRHA BNAO ME NE SUNA HA K DROPDOWN BUTTON SE BAN SKTA HA LEKIN KAISAY?

[syar]

Take a look attached list. If this you need then tell me i'll tell you the complete procedure. K kaise karte hain. Is k elawa aap ye ms query se bhe kar sakte hoo au pivot table k saath bhe. Phele is solution ko deekhen agar aap ki zaroorat pori hoti ha tu theeek warna doosre method aap ko tafseel k saath batata hon. main dobar 6 k baad log on honga.

[arifraza]

1: ALL MEMBER OF IT DUNYA ME NE EXCEL ME ACOUNT SHEET BNANI HA MERI COMPANY ME 1000 CLIENT HEN ME CHATA HON K AISI SHEET BNAO K ME SIRF ACOUNT NO LIKHO TO US ACOUNT KI DETAIL DE DE YANI US KA ADRES CELL NO ETC KIA KOI MJH KO BTA SKTA HA K ME KIS TRHA BNAO ME NE SUNA HA K DROPDOWN BUTTON SE BAN SKTA HA LEKIN KAISAY?

2:
DOSTO ME NE EXCEL ME COMPANY LEDGER BNAYA HA LEKIN EK PROBLEM HA ME CHATA HON K US ME BLANK JAGA 0 NA LIKHA AYE BLANK HO NICHAY DEKHEN
PLS HELP ME URGENTLY WAITING........

G bhai jaan Please check the attached file if this solved your problem for hiding zeros. upper bhi ek bahi nay Solve ki hai aur maine ek dosry Tareeqe se solve ki hai Dekh lo ..