Page 1 of 4 1234 LastLast
Results 1 to 12 of 45

Thread: Excel Sheet Formula

  1. #1
    Shireen Shari is offline Senior Member+
    Last Online
    17th January 2014 @ 09:22 PM
    Join Date
    13 Aug 2009
    Location
    Faisalabad
    Gender
    Female
    Posts
    94
    Threads
    18
    Credits
    960
    Thanked
    4

    Default Excel Sheet Formula



    Mujhey Ye Pochhna Hai.
    Ager Excel Ki 1 File Mein 2 Sheets Hoon.
    Aur 1st Sheet mein Rozana Ke Kaam ki Sumary Hai.
    Aur 2nd Sheet Mein Date wise Monthly Sumary Hai.

    1st sheet ka DATA 2nd Sheet Mein Jis Date Ko Add
    Kiya Jay 2nd Sheet Mein Bi Usi Date Ko Wohi DATA Aa Jay.
    Aur Jis Tarha Date Change Ho.Usi Tarha 2nd Sheet Mein Bi Usi Date Pr
    DATA Apne Aap Aa Jay..

    Exampal
    1 Sheet Mein Rozana DATA Add Kiya Jata Hai.
    Aur 2nd Mein Porey Month Ki Date (1..30) Hai ...
    1st Date Ko Data 1st Sheet Mein Add Kiya.
    Wohi Data 2nd Sheet Mein 1st Date Pr Aa Jay.
    Aur Jab Month Ki 2nd DAte Ho.2nd Date Ka Data Month
    Ki 2nd Date Pr Aa Jay.
    Sheets Sirf 2 Hi Hain.

    Koi Aisa Farmula Bta Dain Jo Date Se Conected Ho..
    Attached Files Attached Files

  2. #2
    *Noor-ul-Ain*'s Avatar
    *Noor-ul-Ain* is offline Senior Member+
    Last Online
    2nd August 2015 @ 06:06 PM
    Join Date
    21 Apr 2012
    Location
    Pakistan
    Age
    25
    Gender
    Female
    Posts
    3,120
    Threads
    79
    Credits
    900
    Thanked
    321

    Default

    آپ کی شیٹ پہ کام کر رہی ہوں
    دعا کیجئے گا کہ کامیاب ہوں جاؤں
    ویسے ایک بات سمجھ نہیں آئی کہ یا تو آپ کو ڈیلی کام کے لیے ہر ایک دن کی الگ شیٹ بنانی ہو گی
    یا ایک ہی شیٹ کافی لمبی ہو جائے گی

  3. #3
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote Shireen Shari said: View Post


    Mujhey Ye Pochhna Hai.
    Ager Excel Ki 1 File Mein 2 Sheets Hoon.
    Aur 1st Sheet mein Rozana Ke Kaam ki Sumary Hai.
    Aur 2nd Sheet Mein Date wise Monthly Sumary Hai.

    1st sheet ka DATA 2nd Sheet Mein Jis Date Ko Add
    Kiya Jay 2nd Sheet Mein Bi Usi Date Ko Wohi DATA Aa Jay.
    Aur Jis Tarha Date Change Ho.Usi Tarha 2nd Sheet Mein Bi Usi Date Pr
    DATA Apne Aap Aa Jay..

    Exampal
    1 Sheet Mein Rozana DATA Add Kiya Jata Hai.
    Aur 2nd Mein Porey Month Ki Date (1..30) Hai ...
    1st Date Ko Data 1st Sheet Mein Add Kiya.
    Wohi Data 2nd Sheet Mein 1st Date Pr Aa Jay.
    Aur Jab Month Ki 2nd DAte Ho.2nd Date Ka Data Month
    Ki 2nd Date Pr Aa Jay.
    Sheets Sirf 2 Hi Hain.

    Koi Aisa Farmula Bta Dain Jo Date Se Conected Ho..
    salam::

    1. agar aap date wise alag alag sheets banate hain tu phir tu asan ha aap sirf sumif/sumproduct/ ya even vlookup bhe baz cases m use kar sakte hain.lekan agar aap ya chahte hain k aap har dafa aik he sheet m entry karain jese k ap ki sheet 1 ha tu mere khyal m namumkin tu nahee lekan bohat mushkil hoga. jis par ak member already kam kar rahe hain.
    2. aap merge cell use kar rahe hain in ko khatam karain warna aap k leye masla ho ga.
    3. aap apna data entry ka layout final kar k share kare k date wise alag sheet ho gi k aik he sheet m entry karin gi. ya aik sheet m aap mazeed sample data enter karian k samajhne m asani ho.

    regards,

  4. #4
    Shireen Shari is offline Senior Member+
    Last Online
    17th January 2014 @ 09:22 PM
    Join Date
    13 Aug 2009
    Location
    Faisalabad
    Gender
    Female
    Posts
    94
    Threads
    18
    Credits
    960
    Thanked
    4

    Default

    Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
    Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
    Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
    Usi Date Pr 2nd Sheet Mein Aa Jay.

  5. #5
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote Shireen Shari said: View Post
    Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
    Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
    Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
    Usi Date Pr 2nd Sheet Mein Aa Jay.
    agar m jahan tak aap ki bat samjha hon.

    sheet1 m aap ki date b2 m ha aur data row 4 m ha.
    agar aap sheet1 m date change karian yani b2 m change karain tu row 4 ka data 2nd sheet m new date k samne add ho jae?

    am i right

  6. #6
    *Noor-ul-Ain*'s Avatar
    *Noor-ul-Ain* is offline Senior Member+
    Last Online
    2nd August 2015 @ 06:06 PM
    Join Date
    21 Apr 2012
    Location
    Pakistan
    Age
    25
    Gender
    Female
    Posts
    3,120
    Threads
    79
    Credits
    900
    Thanked
    321

    Default

    Check This
    Attached Files Attached Files

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    salam Aini::


    Good effort, Nice
    i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

    File ki sheet 1 m aap na sare entries manual ki hain,
    Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
    jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="

  8. #8
    Shireen Shari is offline Senior Member+
    Last Online
    17th January 2014 @ 09:22 PM
    Join Date
    13 Aug 2009
    Location
    Faisalabad
    Gender
    Female
    Posts
    94
    Threads
    18
    Credits
    960
    Thanked
    4

    Default

    Yes Bhai U are right..

  9. #9
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote Shireen Shari said: View Post
    Yes Bhai U are right..
    agar mere bat drust ha tu phir ap jesa chahte hain k sheet1 m entry karte rahin aur data sheet2 m change hota rahe tu asa mumkin nahee. Aap ko phir MACRO use karne pade gi Jis ka m aap ko mashwara nahee donga. Q k aap abhe excel seekh rahe hain tu aap k leye MACRO handle karna masla ho ga. Aur na he aap seekh sakain g.

    Aap khod soche jab aap sheet1 k b2 m date enter karain g tu sheet2 m date ko he base bana kar changes hon gi. lekan jab aap B2 ki date change kar dain gi tu sheet2 m bhe new date k age entry ho gi aur purani date ka data lost ho jae ga.

    Aap har date k leye ak alag sheet bana lain jesa Aini na kaha ha aap ko. Ya aap apna data layout change karian.

  10. #10
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    may be check this thread. its will help u
    http://www.itdunya.com/t310826/

  11. #11
    *Noor-ul-Ain*'s Avatar
    *Noor-ul-Ain* is offline Senior Member+
    Last Online
    2nd August 2015 @ 06:06 PM
    Join Date
    21 Apr 2012
    Location
    Pakistan
    Age
    25
    Gender
    Female
    Posts
    3,120
    Threads
    79
    Credits
    900
    Thanked
    321

    Default

    Quote syar said: View Post
    salam Aini::


    Good effort, Nice
    i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

    File ki sheet 1 m aap na sare entries manual ki hain,
    Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
    jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="
    I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???

  12. #12
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote IamAini said: View Post


    I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???
    asal m mujhy layout ka pata nahee k ya kis tarah entry karain gi. aur m index/match, ya sumproduct, sumif use karta.

Page 1 of 4 1234 LastLast

Similar Threads

  1. Bank Balance Sheet (Excel Prob)
    By Adeawan in forum Ask an Expert
    Replies: 14
    Last Post: 2nd October 2016, 05:04 PM
  2. Want excel formula for this .... problem
    By Nadeem Ahmed Kh in forum Ask an Expert
    Replies: 5
    Last Post: 23rd July 2012, 02:25 PM
  3. sheet 1 ka dusri sheet py formula
    By farooq_18 in forum Ask an Expert
    Replies: 12
    Last Post: 11th June 2011, 01:13 PM
  4. Replies: 1
    Last Post: 27th January 2010, 10:03 PM
  5. excel formula ??
    By adnanbahrian in forum Ask an Expert
    Replies: 5
    Last Post: 22nd February 2009, 11:06 AM

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
  •