Results 1 to 5 of 5

Thread: Sorting excel records by "page"

  1. #1

    Thread Starter
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Question Sorting excel records by "page"

    Our accounting office has this certification being issued for a student and it fits into a short bond paper. All those records are in a single sheet only. Now, we need to save them as PDF but they must be sorted alphabetically using the last name of the student. I am out of ideas on how to do this!

    Anyone who can help? TIA
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  2. #2
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: Sorting excel records by "page"

    dee-u

    I'm a little confused.

    1. Could you possibly post a screenshot of a portion of a sample "page"
    2. How many "sheets" ("pages") might be involved.
    3. Do you want to do this
      • within the WorkBook (ie, VBA macro)
      • using VB6
      • something else


    Spoo

  3. #3

    Thread Starter
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: Sorting excel records by "page"

    It seems it is not possible to attach an excel here. I've posted this also in other forums and here's a link to the sample worksheet.

    There is only a single sheet and if it is not possible to do this via the sorting methods of Excel then perhaps I could utilized VBA for this?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  4. #4
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: Sorting excel records by "page"

    I tried that link .. no luck

    How about attaching an image, you know, like this

    Name:  du1.png
Views: 66
Size:  17.4 KB

    Crop a segment of the sheet
    If you do the whole screen, it'll be too small to read here

    Spoo

  5. #5
    gibra
    Guest

    Re: Sorting excel records by "page"

    Quote Originally Posted by dee-u View Post
    It seems it is not possible to attach an excel here.
    ZIP file, before.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width