Excel problem urgently help me

**shahleopak** · 8th July 2009, 01:10 PM

hello all member of IT Dunya kia koi meri help kare ga me ne ek balance sheet bnani ha MS Excel me mujh ko ye btaye koi k Debter, Credit ka kon sa aisa formula lgay ga k debit or credit sath likha aye me ne file attach kr de ha is ko Excel me bnani ha pls formula b btana ha hum jb entry dalen to wo khus khud he bta de k debt ha ya credit jaisa ka ledger me ha
slam 2 al member plz ager koi janta ha to mujh ko btao me ne Company ki balance sheet bnani ha Excel me
rply me on my ID: shahleo_pak**********
i m waiting................

**ZoOp** · 8th July 2009, 01:25 PM

ok bhai dekhta hn abhi........

**Mubashir Aziz** · 8th July 2009, 01:30 PM

Where is the EXCEL file ?????????????????????????

**shahleopak** · 8th July 2009, 01:35 PM

bahi sahab PDf file me ha jon c me ne attach ki ha us balance sheet ko Excel me bnani ha formula chaye kis trha lgayen ge k DR, CR sath aye pls help me

**Mubashir Aziz** · 8th July 2009, 01:42 PM

Bhai aap akhri column key baat kar rahy hain na jiss main 23,2100.00 CR aur 213,4589.00 DR likha aa raha hay ???

**shahleopak** · 8th July 2009, 01:48 PM

Mubashir bhai ap khud ye ledger bna kr dekhen
9,566.36 DB show ho rha ha us k bad entry show ha ap dekhen k jese he entry dalte hen balance Dr, Cr ho jata ha or han yad rahe k agr hum us me payment dal de to wo balance me add ho jaye us k bad DR ya Cr show ho

**Mubashir Aziz** · 8th July 2009, 02:05 PM

yaar sales ka portion to hogia hay aab aap mujha batain kah purchase main 25,203.04 kiss tarah aa raha hay ????

PURCHASE
Qty CVT Amount
200 .04 25,203.04

**Mubashir Aziz** · 8th July 2009, 02:10 PM

yaar main accounts kay baray main ziyada naheen janta houn yah akhri column main jo debit hay woh minus main hota hay kia keonkah aap kay pass opeining balance 9,566.36 DB tha phir aap key sales hoi 10,864.91 aur opening balance kay neecay 10864.91-9566.36 = 1,298.55 CR likha gia ..... mujhay batain kah sales main say opening balance minus hoga ya kah opening balance main say sales aur agar sales ziyada ho to Credit warna Debit ??? am i right ????

**shahleopak** · 8th July 2009, 02:10 PM

Bhai sahab purchab k rate or quantity ko multiply kr k us me cvt add kr k ata ha ap pls check karen mehrbani ho ge hr entry aisay he ati ha

**Mubashir Aziz** · 8th July 2009, 02:23 PM

Acha bhai hosla karo aru mitha taya rakho .........

**Mubashir Aziz** · 8th July 2009, 02:34 PM

Yah lo bhai file .... last column main main nay Number Format use kia hay InshaAllah jald he details say samjhaon ga ......
Baqi tou simple formula hain Sirf akhri Balance walay column main aap select kar kay Format>Cells>Number -Custom aur phit window main yah format likh daina hay #,##0 "CR";#,##0 "DB"
yah sara kuch iss file main mojood hay aur guide line kay tour par picture bhi bhaij di hay ......

enjoy karain ...

Yaar next time koshish karain Excel key file bana kar bhaijain takah aap ko foran jawab dia ja sakay .... .....

PS. Mithai kub aa rahi hay

**shahleopak** · 8th July 2009, 02:41 PM

bhai sahab mithai to ajaye ge Inshallah lekin mujh ko samajh nhi aye k ap ne kaha ha k number format use karen ge lekin formula kia likhen ge k entry dalen to Dr ya Cr ajaye mujh ko sahi trha smjhaye mehrbani ho ge jnab ki me shukar guzar rahoo ga