-
Oct 3rd, 2017, 08:47 PM
#1
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
-
Oct 4th, 2017, 03:05 AM
#2
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
-
Oct 4th, 2017, 08:22 PM
#3
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?
-
Oct 5th, 2017, 05:03 AM
#4
Re: Sorting excel records by "page"
I tried that link .. no luck
How about attaching an image, you know, like this
Crop a segment of the sheet
If you do the whole screen, it'll be too small to read here
Spoo
-
Oct 6th, 2017, 01:54 AM
#5
Re: Sorting excel records by "page"
Originally Posted by dee-u
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|