View Single Post
  #2   Report Post  
Andrew
 
Posts: n/a
Default

Would using a Concatenate help?, something like:

=HYPERLINK(CONCATENATE
("http://www.usps.com/shipping/trackandconfirm.htm?
from=home&page=",TEXT(A3,"###0"),"trackandconfirm" ),"Click
here")

I'm assuming it's the page number that's changing and that
that A3=35, but you should get the idea anyway.

- Andrew

-----Original Message-----
I am able to make a hyperlink function to open a webpage,
but I am wanting to be able to go webpage by clicking on
the link and automatically put in a tracking number and
press go:

http://www.usps.com/shipping/trackandconfirm.htm?
from=home&page=0035trackandconfirm

Is there a way to do this with the hyperlink function? I
do not know VB yet, so wouldn't even know where to start
in that.

Thanks
.