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
Re: Sorting excel records by "page"
dee-u
I'm a little confused.
- Could you possibly post a screenshot of a portion of a sample "page"
- How many "sheets" ("pages") might be involved.
- Do you want to do this
- within the WorkBook (ie, VBA macro)
- using VB6
- something else
Spoo
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?
1 Attachment(s)
Re: Sorting excel records by "page"
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
Re: Sorting excel records by "page"
Quote:
Originally Posted by
dee-u
It seems it is not possible to attach an excel here.
ZIP file, before.