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!


--
josephrowan
------------------------------------------------------------------------
josephrowan's Profile: http://www.excelforum.com/member.php...o&userid=14407
View this thread: http://www.excelforum.com/showthread...hreadid=534832