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

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

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?

I tried that link .. no luck

How about attaching an image, you know, like this

Attachment 152557

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

Spoo

Quote:

---

Originally Posted by dee-u

It seems it is not possible to attach an excel here.

---

ZIP file, before.