Auto-Sort Hyperlinks
 

Hi,

In our excel file we have one sheet that has 26 seperate paper printout
pages that are filled out by seperate people. Each paper header changes by
the day based upon the job# assigned to it.

We have hyperlinks that autofill the job number at the top of the sheet so
that people can click on the job# and go directly to the page they need.

What I would like to do is be able to have the job numbers sort
chronologically when someone clicks on the worksheet tab so it is easier to
find or not overlook the job number.---Some days people will have more than
one sheet assinged to the same job. Hopefully with all the jobs in order
people will see they have more than one that day. ;-)

I have the hyperlinks that I would like sorted in the following range d3:d28.

Thanks,

ben