J
josephrowan
FedEx
(sorry if this is little long)
I work at a job that has as a part of the day, checking trackin
numbers at Fedex for packages we ship. During peak holidays, th
number of packages to be monitored can number up over 50,000 per da
for the holiday week. In particular, we are scanning for a particula
type of message from the Fedex website that tell us if the package i
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 an
the associated tracking number. It gets divvied up amongst few peopl
and for an hour or so, we slap 25 tracking numbers in at a time at th
website and look for these lost packages. I can usually get throug
about 500 an hour using conventional cut and paste of the trackin
numbers, so the whole process is not *that* bad.
What I want to do is be able is at regular intervals in a column nex
to the tracking numbers is have a link that enters 25 numbers at
time. The problem is that I am running into the character limit on
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 eac
tracking number in the link and provides for a return.
The rest of Column B (starting at B2) contains the formula below an
displays the link labelled "FedEx" and appears at every 12th cell an
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 th
amount of time to get through the whole list. Is there a way to lesse
the load on the cell limit or even have VBA enter the redudant UR
section on double click? the goal here is to track double the amount o
numbers that I am doing now with each click.
Sorry for the long windedness. feel free to <snip> out the bulk of th
message when replying.
thanks
(sorry if this is little long)
I work at a job that has as a part of the day, checking trackin
numbers at Fedex for packages we ship. During peak holidays, th
number of packages to be monitored can number up over 50,000 per da
for the holiday week. In particular, we are scanning for a particula
type of message from the Fedex website that tell us if the package i
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 an
the associated tracking number. It gets divvied up amongst few peopl
and for an hour or so, we slap 25 tracking numbers in at a time at th
website and look for these lost packages. I can usually get throug
about 500 an hour using conventional cut and paste of the trackin
numbers, so the whole process is not *that* bad.
What I want to do is be able is at regular intervals in a column nex
to the tracking numbers is have a link that enters 25 numbers at
time. The problem is that I am running into the character limit on
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 eac
tracking number in the link and provides for a return.
The rest of Column B (starting at B2) contains the formula below an
displays the link labelled "FedEx" and appears at every 12th cell an
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 th
amount of time to get through the whole list. Is there a way to lesse
the load on the cell limit or even have VBA enter the redudant UR
section on double click? the goal here is to track double the amount o
numbers that I am doing now with each click.
Sorry for the long windedness. feel free to <snip> out the bulk of th
message when replying.
thanks