Results 1 to 8 of 8

Thread: Expert help request regarding data in excel

  1. #1
    Amjad_Gondal's Avatar
    Amjad_Gondal is offline Advance Member
    Last Online
    2nd June 2022 @ 02:46 PM
    Join Date
    01 Dec 2009
    Location
    Bhera, Sargodha
    Gender
    Male
    Posts
    656
    Threads
    91
    Credits
    1,375
    Thanked
    18

    Default Expert help request regarding data in excel

    Asslamoalikum.

    humary office me Employee Permanent loan register hai. Jis me tools ya jo be item kisi employee ko issue hoti hai us k nam k lehaz se enter kar d jati hai. Ab boss kehta hai k us register ko excel main maintain karo. aur purana sara data bhe excel me enter kro. 1 option to yeh hai k har employee k liye alag worksheet bane jay...lekn es terh kis aik item ki report mushkal ho jay ge..jesy ager sirf saftey helmat check krny ho kis kis ko issue huwa hai...

    Kindly ap logo se es bary me mashwara chye. aur koi solution bhe. Employees ki tadad 500 k qareeb hai

  2. #2
    Asif_Ali88 is offline Senior Member+
    Last Online
    11th January 2018 @ 11:04 AM
    Join Date
    22 Jan 2017
    Gender
    Male
    Posts
    67
    Threads
    0
    Credits
    443
    Thanked
    4

    Default

    Quote Amjad_Gondal said: View Post
    Asslamoalikum.

    humary office me Employee Permanent loan register hai. Jis me tools ya jo be item kisi employee ko issue hoti hai us k nam k lehaz se enter kar d jati hai. Ab boss kehta hai k us register ko excel main maintain karo. aur purana sara data bhe excel me enter kro. 1 option to yeh hai k har employee k liye alag worksheet bane jay...lekn es terh kis aik item ki report mushkal ho jay ge..jesy ager sirf saftey helmat check krny ho kis kis ko issue huwa hai...

    Kindly ap logo se es bary me mashwara chye. aur koi solution bhe. Employees ki tadad 500 k qareeb hai
    Bht asan he employee k nam k samne har tool k khana bna do or un mn yes no likha karo jb dekhna ho kis kis ko isue he filter mn sirf yes ko tick karo to sirf yes waly record aa jaen ge

    Sent from my XT1080 using Tapatalk

  3. #3
    ramkhans's Avatar
    ramkhans is offline Senior Member+
    Last Online
    17th February 2023 @ 12:13 AM
    Join Date
    23 Oct 2009
    Location
    Hyderabad
    Gender
    Male
    Posts
    77
    Threads
    8
    Credits
    1,674
    Thanked
    3

    Default

    Quote Amjad_Gondal said: View Post
    Asslamoalikum.

    humary office me Employee Permanent loan register hai. Jis me tools ya jo be item kisi employee ko issue hoti hai us k nam k lehaz se enter kar d jati hai. Ab boss kehta hai k us register ko excel main maintain karo. aur purana sara data bhe excel me enter kro. 1 option to yeh hai k har employee k liye alag worksheet bane jay...lekn es terh kis aik item ki report mushkal ho jay ge..jesy ager sirf saftey helmat check krny ho kis kis ko issue huwa hai...

    Kindly ap logo se es bary me mashwara chye. aur koi solution bhe. Employees ki tadad 500 k qareeb hai
    Wallekum assalam
    bro agar har employee k liye 1 sheet banaengy to 500 sheet kese banengy kafi time lag jayega update karny main aur ap khud pareshan hojaogy....
    maximum 5 sheets use karen 1. Data Entry, 2. Summary aur baki jo ap ki requirement hai us hisab se use karen aur agar exel p formulas use karna aty hain to vlookup ko use karen kafi easy hojayega kam...

  4. #4
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    Sab se pehlay aap ek column mein serial no dalein
    2. employee code
    3. employee name
    4. tool issued (item name)

    jab yeh data ban jayay to aap filter ki madad se data sort kar saktay hein (jis cheez ka bhi data maloom karna ho to us cell par right click kar k filter mein ja kar filter by selected cell value ki madad se particular name ya item ka data filter kar saktay ho)

  5. #5
    Syed Hamid Ali's Avatar
    Syed Hamid Ali is offline Senior Member+
    Last Online
    1st April 2018 @ 01:11 PM
    Join Date
    05 Mar 2009
    Location
    Rawalpindi
    Age
    41
    Gender
    Male
    Posts
    359
    Threads
    49
    Credits
    1,048
    Thanked
    32

    Default

    آپ کو اس طرح سمجھ نہیں اے گا آپ کو میرے ساتھ کنٹیکٹ کرنا پڑے گا

  6. #6
    Syed Hamid Ali's Avatar
    Syed Hamid Ali is offline Senior Member+
    Last Online
    1st April 2018 @ 01:11 PM
    Join Date
    05 Mar 2009
    Location
    Rawalpindi
    Age
    41
    Gender
    Male
    Posts
    359
    Threads
    49
    Credits
    1,048
    Thanked
    32

    Default

    سر آپ اس طرح کریں کہ ڈیٹیل ایک طرف مطلب ایک شیٹ میں لکھیں اور
    Concatenate
    کا فارمولا استعمال کریں یا
    Vlookup
    کو استعمال کریں

  7. #7
    Amjad_Gondal's Avatar
    Amjad_Gondal is offline Advance Member
    Last Online
    2nd June 2022 @ 02:46 PM
    Join Date
    01 Dec 2009
    Location
    Bhera, Sargodha
    Gender
    Male
    Posts
    656
    Threads
    91
    Credits
    1,375
    Thanked
    18

    Default

    Thanks All, Bhai filter, vlookup aur Concatenate ka formula ata hai. Allah Pak sab ko khush rakhy.

  8. #8
    ramkhans's Avatar
    ramkhans is offline Senior Member+
    Last Online
    17th February 2023 @ 12:13 AM
    Join Date
    23 Oct 2009
    Location
    Hyderabad
    Gender
    Male
    Posts
    77
    Threads
    8
    Credits
    1,674
    Thanked
    3

    Default

    Quote Amjad_Gondal said: View Post
    Thanks All, Bhai filter, vlookup aur Concatenate ka formula ata hai. Allah Pak sab ko khush rakhy.
    Aameen

Similar Threads

  1. help excel data
    By Rizwan54 in forum Ask an Expert
    Replies: 0
    Last Post: 22nd November 2016, 09:46 AM
  2. Replies: 0
    Last Post: 18th August 2016, 09:48 AM
  3. Excel data type
    By rahe_wafa20 in forum Ask an Expert
    Replies: 5
    Last Post: 7th February 2014, 07:31 PM
  4. Excel data Error pls help
    By Helpme in forum Ask an Expert
    Replies: 3
    Last Post: 27th January 2011, 04:06 PM
  5. Data Base On Excel
    By MJAzam in forum Ask an Expert
    Replies: 5
    Last Post: 10th February 2010, 06:35 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
  •