Results 1 to 5 of 5

Thread: M/S Excel Experts Help Me

  1. #1
    creative_eyes's Avatar
    creative_eyes is offline Senior Member+
    Last Online
    16th May 2020 @ 06:35 PM
    Join Date
    11 Jul 2008
    Location
    SAUDI ARABIA
    Gender
    Male
    Posts
    307
    Threads
    161
    Credits
    1,001
    Thanked
    22

    Default M/S Excel Experts Help Me

    Asalamu Alaikum IT,MEMBERS

    1) Humari Company Me M/S Excel Formate Me Kuch P.O Bane Howa Hien Jo ke Different Different Companys ke Humlog PO No. Kuch Istarha se Add Karten Hine Os Company Wale Folder Me Jakare Jo Sub Se Last Date Per Jo P.O Bana Howa Hota Hi Os P.O Ko Oppen Karke Save As Me Jakar Doosra P.O No Add Karten Hine Jo Ke Wo Sfir,aur Srif Print Preview Me Hi Wo P.O No Nazar aata Hi...aur Hum Log Print Karlete Hien

    2) Ab Yahan Pe Masla Ye Hi Ke Kabi Kabhi Kisi Aur Company Ka P.O Print Preview Me To Wo P.O No Theek Nazar Ata Hi Mugar Jub Hum Print Lete Hine To Wo P.O No Kuch Side Me Print Howa Hota Hi ..............Help Me Please Screen Shot is Attached ( Ye P.O Wala Formate System Phele se Hi ) My Ne Justify/Align Text Bhi Kara P.O Ki Jaga Per
    Attached Images Attached Images    

  2. #2
    ShahbazSuper's Avatar
    ShahbazSuper is offline Advance Member
    Last Online
    16th August 2023 @ 02:56 PM
    Join Date
    21 Nov 2009
    Location
    Punjab
    Age
    34
    Gender
    Male
    Posts
    622
    Threads
    35
    Credits
    2,094
    Thanked
    53

    Default

    attech sheet , phir pata chaly ga k galti khan hai

  3. #3
    creative_eyes's Avatar
    creative_eyes is offline Senior Member+
    Last Online
    16th May 2020 @ 06:35 PM
    Join Date
    11 Jul 2008
    Location
    SAUDI ARABIA
    Gender
    Male
    Posts
    307
    Threads
    161
    Credits
    1,001
    Thanked
    22

    Default

    Quote ShahbazSuper said: View Post
    attech sheet , phir pata chaly ga k galti khan hai
    Asalamu Alaikum Brother i have been attached File
    Attached Files Attached Files

  4. #4
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote creative_eyes said: View Post
    Asalamu Alaikum Brother i have been attached File
    I assume you are using excel 2007/2010/2013

    A. In 1st sheet adjust your Page setup. Go to "VIEW" and then click on page break preview. then adjust right margin.

    B P.O ka no jo print m out ho jata ha is ka solution 2 hain.

    1 solution. Adjust Header of the sheet. Q k file ka name he aap ka purchase order ha. Jo K aap na ya kisi aur na sheet design krte hoe header m file ka name rakha ha aur "Enter" key use krte hoe adjust kya ha. Aap ise adjust kr lain.

    2. ya apna Header Delete kr dain. aur cell m ya formula use karain. Result will be same

    Code:
    =MID(LEFT(CELL("filename",A1), FIND("]", CELL("filename", A1)) - 5),FIND("[", CELL("filename", A1)) + 1, 255)
    Please find the attached file. Sheet 1 contain the above formula and sheet 2 with header solution ( attached by you)

    please feed back agar smjhne m koi masla ho tu btaye ga.

    regards
    Attached Files Attached Files

  5. #5
    creative_eyes's Avatar
    creative_eyes is offline Senior Member+
    Last Online
    16th May 2020 @ 06:35 PM
    Join Date
    11 Jul 2008
    Location
    SAUDI ARABIA
    Gender
    Male
    Posts
    307
    Threads
    161
    Credits
    1,001
    Thanked
    22

    Default

    Quote syar said: View Post
    I assume you are using excel 2007/2010/2013

    A. In 1st sheet adjust your Page setup. Go to "VIEW" and then click on page break preview. then adjust right margin.

    B P.O ka no jo print m out ho jata ha is ka solution 2 hain.

    1 solution. Adjust Header of the sheet. Q k file ka name he aap ka purchase order ha. Jo K aap na ya kisi aur na sheet design krte hoe header m file ka name rakha ha aur "Enter" key use krte hoe adjust kya ha. Aap ise adjust kr lain.

    2. ya apna Header Delete kr dain. aur cell m ya formula use karain. Result will be same

    Code:
    =MID(LEFT(CELL("filename",A1), FIND("]", CELL("filename", A1)) - 5),FIND("[", CELL("filename", A1)) + 1, 255)
    Please find the attached file. Sheet 1 contain the above formula and sheet 2 with header solution ( attached by you)

    please feed back agar smjhne m koi masla ho tu btaye ga.

    regards
    Asalamu Alikum Thanks for your information.Ye jo 2nd Wala option Header Delete Kahan se kiya jata hi my ne (Page Layout + Print Title + Header & Footer Me Header ke Pass P.O No tha wosKo None kardia aur Formula Bar me aapne jo code dia tha wo past kardia) aur Mera masla hall hoga............shukriya

Similar Threads

  1. Only for excel experts....
    By Rizwan Anjum in forum Ask an Expert
    Replies: 3
    Last Post: 2nd February 2014, 05:32 PM
  2. Microsoft Excel Help Needed From ITD Experts....
    By wonderful in forum Ask an Expert
    Replies: 10
    Last Post: 28th January 2014, 06:48 PM
  3. Product wise total in excel sheet kindly help me experts
    By farooq talhar in forum Ask an Expert
    Replies: 4
    Last Post: 20th May 2013, 06:35 PM
  4. Solved EXCEL Experts Please help
    By engr.fahad in forum Solved Problems (IT)
    Replies: 16
    Last Post: 24th June 2012, 01:15 PM
  5. Help for Microsoft Excel 2007 Experts
    By abdul wahab 1 in forum Ask an Expert
    Replies: 1
    Last Post: 14th April 2012, 09:46 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
  •