You need to cheat and do one manually. Say you go to a site and want data on
record 31415926. You perform the entry and the web site displays the data.
You also save the URL. Say it is:
http://www.qwerty.com/hvkhvhvfdhvd31415926
In column A in A1 enter:
31415926 and in B1 enter:
=HYPERLINK("http://www.qwerty.com/hvkhvhvfdhvd" & A1,A1) and copy down
--
Gary''s Student - gsnu200793
"robinrobin" wrote:
I am creating lists that contain current in transit FedEx tracking numbers.
I would like to format the column in Excel that would let each tracking
number link to FedEx and go the the tracking information that is specific to
the package. I have seen this done and have received these back to me but
the formula that is showing I can not copy and paste and keep the tracking
information locked to the current cell. It just brings the old tracking
number forward.