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
.