Results 1 to 5 of 5

Thread: Problem In Ms Excel

  1. #1
    iamaraza is offline Senior Member+
    Last Online
    13th December 2023 @ 06:22 PM
    Join Date
    03 Feb 2013
    Location
    Karachi
    Gender
    Male
    Posts
    174
    Threads
    19
    Credits
    1
    Thanked
    6

    Default Problem In Ms Excel

    Salam mein aaj excel pe kam kar raha tha lekin 1 masla a gaya masla yeh k
    mein jab range k total ko copy karta hun to range bhi move ho jati hai plz iska koi hal bata den apki asani k liye mein screen shot bhi diye hein



    http://www.mediafire.com/view/2tsh0w1db6mmpck/Excel.avi
    Attached Images Attached Images   
    Attached Files Attached Files
    Last edited by iamaraza; 10th December 2013 at 07:52 AM.

  2. #2
    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 iamaraza said: View Post
    Salam mein aaj excel pe kam kar raha tha lekin 1 masla a gaya masla yeh k
    mein jab range k total ko copy karta hun to range bhi move ho jati hai plz iska koi hal bata den apki asani k liye mein screen shot bhi diye hein
    Walikum

    Jab aap ranges ko excel m copy kr k paste krte hain tu excel automatically references copy kr leta ha is ko relatives reference kaha jata ha. jese aap k case m ha. agar tu aap ka data k same layout ha tu ya beneficiant hota ha lkn aap k case m asa nahee. Aap ki ranges m data aik jasa nahee is leye aap ko formula manual lekhan ho ga.


    lkn agar aap ranges ka total copy krna chahte hian tu try make ranges absolute by pressing F4 when moving around ranges. phr jab aap copy kariange formula ko tu use range ka total ya formula copy ho ga jo pahli range ka total dekhai ga.

    regards,

  3. #3
    iamaraza is offline Senior Member+
    Last Online
    13th December 2023 @ 06:22 PM
    Join Date
    03 Feb 2013
    Location
    Karachi
    Gender
    Male
    Posts
    174
    Threads
    19
    Credits
    1
    Thanked
    6

    Default

    Apne Solution Nahi bataya

  4. #4
    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 iamaraza said: View Post
    Apne Solution Nahi bataya
    jesa aap chahte ho mere ilam k mutabiq wesa nahee ho skata except k jab aap ki ranges same na hon. agar aap apna masla zara mazed explain karain tu bahtar ho ga. ya apne sheet attached kr dian.

    agar aap n sirf total copy krna ha ya sirf total chahte hain tu sirf "=" k sign k sath cell reference de dain.

    for example as per your screen shot your first total is in H8. agar aap iske total ko dosre screen shot k mutabiq I9 m chahte hain tu try simple in I9

    =H8



    regards

  5. #5
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    اس فائل پر چیک کریں
    Attached Files Attached Files

Similar Threads

  1. MS Excel & Word Print Problem
    By Qutab in forum Ask an Expert
    Replies: 1
    Last Post: 28th July 2012, 10:59 AM
  2. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 3
    Last Post: 22nd October 2011, 10:16 PM
  3. Microsoft Excel 2007 Problem
    By Sarfraz Hussain in forum Ask an Expert
    Replies: 6
    Last Post: 21st October 2011, 12:30 PM
  4. excel formate & file opening problem
    By Fareed Ahmed in forum Ask an Expert
    Replies: 3
    Last Post: 19th December 2009, 09:14 AM
  5. Excel Problem....
    By Adeawan in forum Ask an Expert
    Replies: 3
    Last Post: 6th March 2009, 06:15 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
  •