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

Thread: Plz help me urgent in excel

  1. #1
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Thumbs down Plz help me urgent in excel



    SIR MAIN SHEET ATTACH KER DI HAY OUR MAIN CHATA HON K SHEET2 WALI QTY SHEET1 K COLUM NUMBER H YANI SALE WALAY MAIN AUTOMATICLY PUT HO JAY MARA MAQSAD YE HAY KEH MAIN AK AK CODE KI SALE NO NIKALO BALKAY KHUD BA KHUD US CODE KO FOLLOW KERTAY HO SALE WALAY COLUM MAIN QTY PUT HO JAY

    MAIN AP KA BEHAD SHUKERGUZAR HON GA PLEEEEEEEEZ URGENT HELP ME
    Attached Files Attached Files

  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



    1. as per my understanding put this formula in sheet1

    cell H5 and copy down as far as required

    Code:
    =IF(COUNTIF(Sheet2!$A$5:$A$160,sheet1!$A5)>0,VLOOKUP(A5,Sheet2!$A$4:$C$160,3,0),"")
    May be this will help you. Agar koi masla ho tu zaroor batyae ga.

    2. Agar aap jo sheet bhee is forum me share karain aur us me Macro istimal ki ho tu bataya karain. Kyon ka zyada tar logong ko pata nahee hota ka kuch codes harmful hote hain. Jo shayad istimal karne wale ko bhee pata nahee hote. Please sheet share karte waqt aap ne Macro istimal ki ha tu zaroor bataye ga.

    Regards,

  3. #3
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Thumbs down formula lag gaya


    sory sir es main macro ka istamal nahi hay main ne formula put kia hay just main chata hon k jo sale mujhey di gai hay us ko main dispatch karon laken es formula main sale zayda nakal jati hay just wohi qty total ho jo sheet2 main total hay same qty put honi chye .

    thx plz reply zaroor karain .
    Attached Files Attached Files

  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

    Salam:

    m zara samjhna Chahta hon
    AAp ka item No.F10519 ka opening balance ha 186 ( Row Number 47)
    Isis tarah Row Number 48,49,50,51,52,53 m same item ka leye different opening balance ha.jab ka sheet 2 pa aap ka sale ya jo kuch bhee ha us me item repeate nahee hoe sirf aik he qty ha.
    Aap aisa karain ka mujhe samjhane ka leye aik dosri sheet me sirf Item NO. F10519 ka data lekhain aur jo aap out put chahte hain lekh dain manual aap lekhain ta ka m samjh sakoon. Aur formula m laga donge. Pehle tu me samajh sakoon k aap chahte kya hain.

    regards

  5. #5
    kamranshahr's Avatar
    kamranshahr is offline Senior Member+
    Last Online
    16th May 2023 @ 02:05 PM
    Join Date
    10 Apr 2009
    Location
    desert of sorrow
    Gender
    Male
    Posts
    495
    Threads
    67
    Credits
    1,264
    Thanked
    35

    Default

    Quote sabir sami said: View Post


    SIR MAIN SHEET ATTACH KER DI HAY OUR MAIN CHATA HON K SHEET2 WALI QTY SHEET1 K COLUM NUMBER H YANI SALE WALAY MAIN AUTOMATICLY PUT HO JAY MARA MAQSAD YE HAY KEH MAIN AK AK CODE KI SALE NO NIKALO BALKAY KHUD BA KHUD US CODE KO FOLLOW KERTAY HO SALE WALAY COLUM MAIN QTY PUT HO JAY

    MAIN AP KA BEHAD SHUKERGUZAR HON GA PLEEEEEEEEZ URGENT HELP ME
    brother ye to bohut easy hay appki value khud ba khud ajegy but agar aap apne pahley hyy item ko dekho to wooh item aapki sheet one mein to hay magar sheet 2 mein nahin hay.
    lakin aapko assan hal bta deta hoo kaay apko jo bhi value sheet 2 ya sheet one mein leni hoon uskay lie ye step karen.
    aap 'H' mein value lana chahtey hein simple.
    step1: 'H' kay us cell mein jaaen jahan apko value leni hay or "=" press karen.
    step2: kuch mat karen sirf sheet 2 per click karein or os cell per click krdein jo value aap lena chahtay hein 'H' mien code kay hisaab say.
    step3: press enter apki value automaticaly sheet 1 mein ajaegy.
    check karein or
    reply karen
    Last edited by kamranshahr; 1st July 2011 at 12:23 PM.

  6. #6
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Default

    Quote syar said: View Post
    Salam:

    m zara samjhna Chahta hon
    AAp ka item No.F10519 ka opening balance ha 186 ( Row Number 47)
    Isis tarah Row Number 48,49,50,51,52,53 m same item ka leye different opening balance ha.jab ka sheet 2 pa aap ka sale ya jo kuch bhee ha us me item repeate nahee hoe sirf aik he qty ha.
    Aap aisa karain ka mujhe samjhane ka leye aik dosri sheet me sirf Item NO. F10519 ka data lekhain aur jo aap out put chahte hain lekh dain manual aap lekhain ta ka m samjh sakoon. Aur formula m laga donge. Pehle tu me samajh sakoon k aap chahte kya hain.

    regards
    plz check sheet jis tarah main chata hon attach file.plz jetna jaldi ho sake jawab dena ap ka buhat buhat shukeria
    thx
    Attached Files Attached Files

  7. #7
    kamranshahr's Avatar
    kamranshahr is offline Senior Member+
    Last Online
    16th May 2023 @ 02:05 PM
    Join Date
    10 Apr 2009
    Location
    desert of sorrow
    Gender
    Male
    Posts
    495
    Threads
    67
    Credits
    1,264
    Thanked
    35

    Default

    Quote sabir sami said: View Post

    sory sir es main macro ka istamal nahi hay main ne formula put kia hay just main chata hon k jo sale mujhey di gai hay us ko main dispatch karon laken es formula main sale zayda nakal jati hay just wohi qty total ho jo sheet2 main total hay same qty put honi chye .

    thx plz reply zaroor karain .
    bhai ye check karoo mein apko bata chuka hoo key ye bohut simple hay aap apni sheet2 mein value enter karo or sheet1 dekho.
    Attached Files Attached Files

  8. #8
    kamranshahr's Avatar
    kamranshahr is offline Senior Member+
    Last Online
    16th May 2023 @ 02:05 PM
    Join Date
    10 Apr 2009
    Location
    desert of sorrow
    Gender
    Male
    Posts
    495
    Threads
    67
    Credits
    1,264
    Thanked
    35

    Default

    dost aap ye screen shots dekhein.
    Attached Images Attached Images  

  9. #9
    kamranshahr's Avatar
    kamranshahr is offline Senior Member+
    Last Online
    16th May 2023 @ 02:05 PM
    Join Date
    10 Apr 2009
    Location
    desert of sorrow
    Gender
    Male
    Posts
    495
    Threads
    67
    Credits
    1,264
    Thanked
    35

    Cool

    Attached Images Attached Images  

  10. #10
    kamranshahr's Avatar
    kamranshahr is offline Senior Member+
    Last Online
    16th May 2023 @ 02:05 PM
    Join Date
    10 Apr 2009
    Location
    desert of sorrow
    Gender
    Male
    Posts
    495
    Threads
    67
    Credits
    1,264
    Thanked
    35

    Default

    Attached Images Attached Images  

  11. #11
    sabir sami is offline Senior Member+
    Last Online
    11th December 2016 @ 08:10 PM
    Join Date
    22 Dec 2010
    Location
    MULTAN
    Age
    38
    Gender
    Male
    Posts
    143
    Threads
    65
    Credits
    11
    Thanked
    2

    Default check again file dost

    Quote kamranshahr said: View Post

    plz dear check again file i want to same qty put on sheet1 from sheet2
    Attached Files Attached Files

  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



    Cell H5 m
    Code:
    =IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$C$5>SUM(sheet1!A$5:$E5),sheet1!$E5,sheet1!$E$5-SUM(sheet1!A$5:$E5)))
    Cell H6 main aur copy down as far as required

    Code:
    =IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$C$5>SUM(sheet1!A$5:$E6),sheet1!$E6,Sheet2!$C$5-SUM(sheet1!A$5:$E5)))

    may be this will help you. Enhance this formula a bit as per your requirement. agar phir bhee problem ho tu bataye ga.

    Waise brother aap apna purana thread
    Code:
    http://www.itdunya.com/t258601-2/
    bhe check kar lain. Ye tu mujh ko abhee yad aaya ha.

    regards

Page 1 of 2 12 LastLast

Similar Threads

  1. urgent help for excel
    By kamibest in forum Ask an Expert
    Replies: 3
    Last Post: 16th November 2015, 06:12 PM
  2. Need Hel p in Excel.......... urgent.
    By ihsandani in forum Ask an Expert
    Replies: 0
    Last Post: 4th February 2015, 02:42 PM
  3. Solved excel help urgent
    By MOuzzam shamim in forum Solved Problems (IT)
    Replies: 5
    Last Post: 22nd May 2014, 09:59 AM
  4. Excel ---- urgent help
    By decent_soldiers in forum Ask an Expert
    Replies: 2
    Last Post: 17th April 2010, 10:52 AM
  5. urgent excel help plz plz plz
    By wahidshaiq in forum Ask an Expert
    Replies: 8
    Last Post: 30th March 2010, 05:12 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
  •