Page 1 of 2 12 LastLast
Results 1 to 12 of 15

Thread: Bank Balance Sheet (Excel Prob)

  1. #1
    Adeawan's Avatar
    Adeawan is offline Analyst
    Last Online
    27th July 2021 @ 09:17 AM
    Join Date
    31 Oct 2006
    Location
    Clifton Karachi
    Gender
    Male
    Posts
    3,051
    Threads
    158
    Credits
    559
    Thanked
    15

    Unhappy Bank Balance Sheet (Excel Prob)

    Assalam-o-Alaikum, Doston mujhe Excel Formulas mai aap ki Help chaye hai.... Masla yeh hai k main apne Bank Account ki Balance Sheet banana chahta hun.... main chahta hun jab mai Debit ya Credit likhon to Automatic har entry ka Balance, Balance Column mai aajye... agar woh Balance Debit mai ho to Status k Column mai Dr aur agar Credit ka ho to Cr Automatic aajye.... Sample k toor par mai Excel Sheet aur Screen Shot Upload kar raha hun.... aap dekh saktay hain... agar kissi Brother ko Excel mai achi Command hai to please Help zaroor kijye ga

    Regards

    Adeawan


    Name:  Samp Ex.jpg
Views: 11363
Size:  101.2 KB
    Attached Files Attached Files

  2. #2
    Rahym.Zulfiqar.Aly is offline Member
    Last Online
    20th February 2010 @ 06:21 PM
    Join Date
    12 Jul 2008
    Posts
    1,913
    Threads
    243
    Thanked
    9

    Thumbs up


    Adeawen Bhai
    Kaisay hai aap ?
    Umeed hai k Khairyaat say hoon gai
    Bhai jaan aap k problem ka solution mill gaya hai

    May nay Ek Excel ki sheet attach ki hai uss ko download karain aur formula dekh lain
    Formulay ka kaam karne ka tariqa yeh hai k
    Aap sab say phelay Debit and Credit ki amounts Unn k columns may likh lain then aap ek cell may jo formula lagaiin gai uss ko drag kaar lain jo amount jahan ho gi tau Debit ya Credit likha huwa aaa jaye gaa

    Agar aap ko phir b samjh nahi aaye tu reply karna and agar problem solve ho jaye tu b reply zaroor karna

    Attached Files Attached Files

  3. #3
    Adeawan's Avatar
    Adeawan is offline Analyst
    Last Online
    27th July 2021 @ 09:17 AM
    Join Date
    31 Oct 2006
    Location
    Clifton Karachi
    Gender
    Male
    Posts
    3,051
    Threads
    158
    Credits
    559
    Thanked
    15

    Default

    Quote Rahim.Zulfiqar said: View Post

    Adeawen Bhai
    Kaisay hai aap ?
    Umeed hai k Khairyaat say hoon gai
    Bhai jaan aap k problem ka solution mill gaya hai

    May nay Ek Excel ki sheet attach ki hai uss ko download karain aur formula dekh lain
    Formulay ka kaam karne ka tariqa yeh hai k
    Aap sab say phelay Debit and Credit ki amounts Unn k columns may likh lain then aap ek cell may jo formula lagaiin gai uss ko drag kaar lain jo amount jahan ho gi tau Debit ya Credit likha huwa aaa jaye gaa

    Agar aap ko phir b samjh nahi aaye tu reply karna and agar problem solve ho jaye tu b reply zaroor karna

    Walaikum Salam Rahim Bhai, Main theak hun aur umeed karta hun aap bhi khariyat se hun gay,,,, Brother, aap jo tareeqa bataya hai woh apni jaga durust hai... Lakin actualy mera masla Defferent hai... Shayed mai sahi tarha wazahat nahi kar sakka... Khair mai Wazeh karnay ki koshish karta hun....

    Masla Darasal yeh hai k Main chahta hun Jab mai Debit ya Credit Column mai koi amount likhon to Balance k Column mai woh Ammount Balance ho kar aayaje... eg; Jease Pic mai likha hai... maine 10,000 Debit kiye hain to Zahir hai k Balance bhi Debit mai aaye ga... es liye Status column mai Dr likha hai... main chahta hun k ammount Balance bhi Auto ho har Row ki aur Status column mai Balance Status bhi aajye k Balance Debit hai ya credit....!

    agar samajhne mai koi kami reh gai ho to Pls puch lijiye ga... Masla inportent hai... Solution Matloob hai

    Humble Regards

    Adeawan

  4. #4
    Silver Eyes's Avatar
    Silver Eyes is offline Senior Member+
    Last Online
    25th December 2022 @ 02:11 PM
    Join Date
    21 Feb 2007
    Posts
    257
    Threads
    61
    Credits
    14
    Thanked: 1

    Default

    ye len apka masla hal kar dia, file attach kar di
    Attached Files Attached Files

  5. #5
    Adeawan's Avatar
    Adeawan is offline Analyst
    Last Online
    27th July 2021 @ 09:17 AM
    Join Date
    31 Oct 2006
    Location
    Clifton Karachi
    Gender
    Male
    Posts
    3,051
    Threads
    158
    Credits
    559
    Thanked
    15

    Default

    Quote Silver Eyes said: View Post
    ye len apka masla hal kar dia, file attach kar di
    Sir Bilkul mujhe yehi chaye tha... Thank you soo Much

    ab Dosra masla bhi Solve kar dian to meharbni ho gi... woh yeh k Jis ka Balance ho (Debit ka ya Credit ka) tou Status k column mai Dr ya Cr aajye... agar yeh mumkin nahi to phir Balance k Column mai agar Balance Credit ka hoto Text Red Color mai jaye...

    Waiting for Reply....

  6. #6
    shahzebawan's Avatar
    shahzebawan is offline Senior Member+
    Last Online
    3rd August 2012 @ 05:56 AM
    Join Date
    13 Aug 2007
    Posts
    446
    Threads
    12
    Credits
    940
    Thanked
    0

    Default

    Sorry Cant Help You
    Not Sure About This .....

  7. #7
    Silver Eyes's Avatar
    Silver Eyes is offline Senior Member+
    Last Online
    25th December 2022 @ 02:11 PM
    Join Date
    21 Feb 2007
    Posts
    257
    Threads
    61
    Credits
    14
    Thanked: 1

    Default

    ye lo janab
    Attached Files Attached Files

  8. #8
    Adeawan's Avatar
    Adeawan is offline Analyst
    Last Online
    27th July 2021 @ 09:17 AM
    Join Date
    31 Oct 2006
    Location
    Clifton Karachi
    Gender
    Male
    Posts
    3,051
    Threads
    158
    Credits
    559
    Thanked
    15

    Default

    Thank you Brother,,, Meri Problem kaafi hadd tak solve ho gai hai... aap ka mashkoor hun... Masha Allah Excel par aap ki achi grip hai... Good

    Brother agar mumkin ho to ease bhi dekh lijiye ga...

    http://www.itdunya.com/showthread.php?t=61569

    Adeawan

  9. #9
    ~*SEEP*~'s Avatar
    ~*SEEP*~ is offline Senior Member+
    Last Online
    7th March 2016 @ 07:32 PM
    Join Date
    13 Nov 2006
    Location
    Khawaboon Main ...
    Posts
    13,136
    Threads
    745
    Credits
    -20
    Thanked
    410

    Default

    Quote Adeawan said: View Post
    Thank you Brother,,, Meri Problem kaafi hadd tak solve ho gai hai... aap ka mashkoor hun... Masha Allah Excel par aap ki achi grip hai... Good

    Brother agar mumkin ho to ease bhi dekh lijiye ga...

    http://www.itdunya.com/showthread.php?t=61569

    Adeawan

    Baqi Bhi Hall Hoojay ga

  10. #10
    smsaeed is offline Senior Member+
    Last Online
    14th November 2017 @ 01:27 PM
    Join Date
    23 Oct 2008
    Posts
    67
    Threads
    4
    Credits
    1,015
    Thanked
    3

    Default

    salam yar ap ka color anay ka masla hal howa ya nahi agar nahi to format menu main condition format main akar ap kam karskatya hay agar ap karna chey to plz bataday main ap ko mukammal batadonga
    saeed

  11. #11
    sannan is offline Senior Member+
    Last Online
    16th October 2012 @ 10:36 AM
    Join Date
    17 Feb 2009
    Age
    43
    Posts
    38
    Threads
    4
    Credits
    0
    Thanked
    0

    Default

    Lo Bhai Tumhara Masla Hal Howa .....
    Attached Files Attached Files

  12. #12
    Abdullah is offline Senior Member+
    Last Online
    19th February 2014 @ 03:39 AM
    Join Date
    05 Jul 2006
    Posts
    569
    Threads
    10
    Credits
    0
    Thanked
    3

    Default

    Nice Yar

Page 1 of 2 12 LastLast

Similar Threads

  1. MCB bank balance Check
    By Khizersharif in forum Ask an Expert
    Replies: 11
    Last Post: 2nd May 2017, 04:04 PM
  2. Excel aik Sheet se dosri sheet mein data up date kerna
    By riazanjum09 in forum General Discussion
    Replies: 2
    Last Post: 16th January 2014, 01:15 AM
  3. Aik Excel Sheet Say Data Dosri Sheet Main Daikhna !!!
    By sannan in forum General Discussion
    Replies: 13
    Last Post: 29th January 2010, 11:16 PM
  4. Replies: 1
    Last Post: 27th January 2010, 10:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •