Results 1 to 11 of 11

Thread: Microsoft Excel Help Needed From ITD Experts....

  1. #1
    wonderful is offline Senior Member+
    Last Online
    9th November 2015 @ 09:20 AM
    Join Date
    15 Jun 2007
    Location
    Karachi
    Gender
    Male
    Posts
    1,010
    Threads
    170
    Credits
    0
    Thanked
    42

    Thumbs down Microsoft Excel Help Needed From ITD Experts....

    Microsoft Excel Help Needed From ITD Experts....

    Assalam-u-alaykum

    Doustoun Mujhe Ms Excel Ke Hawale Se Aik Baat Poochni Aur seekhni Hai , Umeed Kartha Hun Itd Ke Pyaaare Members Meri Help Karenge ..

    Baat Yeh HAi----

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....
    AAP SAB SE GUZAARISH HA
    MERE PYAARE BHAI "Muhammad Ahsan" (MARHOOM)KE LIYE DUA E MAGFIRAT KIJYE GAA ALLAH UNHEN JANNAT UL FIRDOUS MAI JAGA ATAA FARMAAYE..

  2. #2
    wonderful is offline Senior Member+
    Last Online
    9th November 2015 @ 09:20 AM
    Join Date
    15 Jun 2007
    Location
    Karachi
    Gender
    Male
    Posts
    1,010
    Threads
    170
    Credits
    0
    Thanked
    42

    Default

    Koiieee toh bataye

  3. #3
    wonderful is offline Senior Member+
    Last Online
    9th November 2015 @ 09:20 AM
    Join Date
    15 Jun 2007
    Location
    Karachi
    Gender
    Male
    Posts
    1,010
    Threads
    170
    Credits
    0
    Thanked
    42

    Default

    ?? itd memberz plz help

  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 wonderful said: View Post
    Microsoft Excel Help Needed From ITD Experts....

    Assalam-u-alaykum

    Doustoun Mujhe Ms Excel Ke Hawale Se Aik Baat Poochni Aur seekhni Hai , Umeed Kartha Hun Itd Ke Pyaaare Members Meri Help Karenge ..

    Baat Yeh HAi----

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....
    Kya aap apni sample files yahan share kr sakte hian?
    Aap files ko "=" k sign k zarye link kr sakte hian. See Urdu Tutorial k section m Excel help line m Faisal sb ki aik sharing ha use study karin, agar aap ka masla hal ho jata ha is sa. Lekan aap jo chah rahe ahin is m formula apply krne honge. Is leye agar aap sample file share kr lain tu smjhne m asane ho gi k kis trah ka aur konsa data kis kis file m jaega.


    If your are using excel 2007 then use Save as workspace option jo k aap ki situation m useful rahe ga. k aap ki same file aik sath open and close honge. Unfortunately 2013 m ya function nahee ha.


    regards,

  5. #5
    wonderful is offline Senior Member+
    Last Online
    9th November 2015 @ 09:20 AM
    Join Date
    15 Jun 2007
    Location
    Karachi
    Gender
    Male
    Posts
    1,010
    Threads
    170
    Credits
    0
    Thanked
    42

    Default

    Dear Syar Bhai Samajah NAhi Aaya

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

    Default

    بھائی ذرا سمجھائیں کیا آپ یہ چاہ رہے ہیں کہ آپ ایک لنک پر کلک کریں تو یہ تینوں فائلز ایک ساتھ کھل جائیں

  7. #7
    wonderful is offline Senior Member+
    Last Online
    9th November 2015 @ 09:20 AM
    Join Date
    15 Jun 2007
    Location
    Karachi
    Gender
    Male
    Posts
    1,010
    Threads
    170
    Credits
    0
    Thanked
    42

    Default

    Sahil Bhai Issue Yeh Nahi Ke Aik Saath Khul Jaayen

    Issue Yeh Hai Ke 3noun File Automaticaly Update Hothi Rahen Sirf Aik File MAi Data Enter Karne Se

    Baat Ko Aasaan Andaaz Mai Bayaan Karne Ki Koshish Kartha Hun:-

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....

    Umeed Hai Ub Aa Logoun Ko Help Karne Mai Assaani Hogi

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

    Default

    آپ یہ چاہ رہے ہیں کہ آپ ایک فائل پر کوئی چیز اپڈیٹ کریں تو وہ باقی دو فائل پر خود بخود اپڈیٹ ہو جائے آپ کو ان کو مینیویل اپڈیٹ نہ کرنا پڑے

  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 wonderful said: View Post
    Sahil Bhai Issue Yeh Nahi Ke Aik Saath Khul Jaayen

    Issue Yeh Hai Ke 3noun File Automaticaly Update Hothi Rahen Sirf Aik File MAi Data Enter Karne Se

    Baat Ko Aasaan Andaaz Mai Bayaan Karne Ki Koshish Kartha Hun:-

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....

    Umeed Hai Ub Aa Logoun Ko Help Karne Mai Assaani Hogi
    How link two worksheets/workbooks visit this thread and start reading from POST NO. 162

    http://www.itdunya.com/t300546-14/

    is m simple method btaya gaya ha.

  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

    Quote wonderful said: View Post
    Sahil Bhai Issue Yeh Nahi Ke Aik Saath Khul Jaayen

    Issue Yeh Hai Ke 3noun File Automaticaly Update Hothi Rahen Sirf Aik File MAi Data Enter Karne Se

    Baat Ko Aasaan Andaaz Mai Bayaan Karne Ki Koshish Kartha Hun:-

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....

    Umeed Hai Ub Aa Logoun Ko Help Karne Mai Assaani Hogi
    Excel m pahly aik COMMAND ata tha jese "SAVE AS WORKSPACE" kahte the. is ka ya faida hota tha k aap jin aik jese files, ya wo files jo aik dosre sa related hote the un ko aik sath open kr k un ka group bana lete, tu ya files aik sath open aur close hote. Jese aap ki 3 files hain, stock, production and Billing, ya files aik dosre sa related hain. lkn ab save as workspace ka option excel 2013 m nahee ha, 2010 tak available ha. agar app 2010/2007/2003 use k krte hain tu apne files ko save as workspace k zrya save kr lain. Q k automatic update k leye sae files open hon. close files update nahee hote.

    regards

  11. #11
    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 wonderful said: View Post
    Sahil Bhai Issue Yeh Nahi Ke Aik Saath Khul Jaayen

    Issue Yeh Hai Ke 3noun File Automaticaly Update Hothi Rahen Sirf Aik File MAi Data Enter Karne Se

    Baat Ko Aasaan Andaaz Mai Bayaan Karne Ki Koshish Kartha Hun:-

    Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

    Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
    Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

    Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

    Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....

    Umeed Hai Ub Aa Logoun Ko Help Karne Mai Assaani Hogi
    agar oper deye gay link ki madad sa aap ka masla hal nahee hota, tu aap apne files yahan share karain aur thoda sa hr file me explain kr dain ka konsa data aap ko link krna ha.

    is maqsad k leye aap different formulas bhe use kr sakte hian jese VLOOKUP, SUMIF etc. lkn pahly aap oper deye gai link ko try karain. phr formula ki traf aate hain. wrna aap confuse hote rahainge.

    aap ki confusion ki wajha sa he m n alag alag rply lekhe hain,

    regards

Similar Threads

  1. Almost All File Formats and their Meanings
    By n0mi in forum General Discussion
    Replies: 20
    Last Post: 26th September 2015, 11:53 AM
  2. Replies: 4
    Last Post: 7th October 2013, 06:07 PM
  3. help for microsoft excel
    By Wajid_Quresh in forum Ask an Expert
    Replies: 0
    Last Post: 11th August 2013, 08:25 PM
  4. Microsoft Excel 2000 Has A Hidden Game
    By Secretz in forum Computer Articles
    Replies: 38
    Last Post: 27th March 2013, 02:57 PM
  5. i want microsoft excel portable working link
    By ali_ahmad in forum Ask an Expert
    Replies: 1
    Last Post: 22nd November 2012, 08:25 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
  •