FedEx
(sorry if this is little long)

I work at a job that has as a part of the day, checking tracking numbers at Fedex for packages we ship. During peak holidays, the number of packages to be monitored can number up over 50,000 per day for the holiday week. In particular, we are scanning for a particular type of message from the Fedex website that tell us if the package is stuck in the ether. We then take action to get it moving.

So, each day I get of list of order numbers, other pertinant info and the associated tracking number. It gets divvied up amongst few people and for an hour or so, we slap 25 tracking numbers in at a time at the website and look for these lost packages. I can usually get through about 500 an hour using conventional cut and paste of the tracking numbers, so the whole process is not *that* bad.

What I want to do is be able is at regular intervals in a column next to the tracking numbers is have a link that enters 25 numbers at a time. The problem is that I am running into the character limit on a cell and am limited to only 12 tracking numbers per click.

First off......
Column A starting with A2, contains the list of tracking Numbers
Cell B1 contains the string "%0D%0A" which is placed between each tracking number in the link and provides for a return.
The rest of Column B (starting at B2) contains the formula below and displays the link labelled "FedEx" and appears at every 12th cell and links the following 12 tracking numbers

Here is the formula....
=HYPERLINK("http://www.fedex.com/Tracking?tracknumbers="&A2&$B$1&A3&$B$1&A4&$B$1&A5&$B$1&A6&$B$1&A7&$B$1&A8&$B$1&A9&$B$1&A10&$B$1&A11&$B$1&A12&$B$1&A13,"FedEx")

This works just fine for 12 numbers, but it adds signifigantly to the amount of time to get through the whole list. Is there a way to lessen the load on the cell limit or even have VBA enter the redudant URL section on double click? the goal here is to track double the amount of numbers that I am doing now with each click.

Sorry for the long windedness. feel free to <snip> out the bulk of the message when replying.

thanks!