Is this possible? (Circular reference?)

[Big UT Fan]

I'm using Excel 2002. Here's is what I'd like to do...imagine a column of
whole numbers which represent anything...a 5 digit zip code for example. I'd
like a function or formula that I could apply to all the cells in the ZipCode
column. This function would hyperlink to a url which includes the zipcode.
I believe this is called a circular reference. I'd like this automated or
done as effortlessly as possible. Here is how I currently accomplish
this...enter the zip codes into the spreadsheet; go to the url which includes
the zip code in the url path; highlight the url and copy <ctrl-c>; create a
hyperlink in the corresponding cell and paste <ctrl-v> the url. This is very
cumbersome. That probably isn't very clear but any help would be greatly
appreciated. Thanks, Mike

 

[MyVeryOwnSelf]

I'm using Excel 2002. Here's is what I'd like to do...imagine a

column of whole numbers which represent anything...a 5 digit zip code
for example. I'd like a function or formula that I could apply to all
the cells in the ZipCode column. This function would hyperlink to a
url which includes the zipcode. I believe this is called a circular
reference. I'd like this automated or done as effortlessly as
possible. Here is how I currently accomplish this...enter the zip
codes into the spreadsheet; go to the url which includes the zip code
in the url path; highlight the url and copy <ctrl-c>; create a
hyperlink in the corresponding cell and paste <ctrl-v> the url. This
is very cumbersome. That probably isn't very clear but any help would
be greatly appreciated. Thanks, Mike

Here's something a bit easier, but not quite what you asked for.

Suppose column A is a list of zip codes.

In B1, put (for example)
=HYPERLINK("http://www.weather.com/outlook/homeandgarden/garden/tenday/"
&TEXT(A1,"00000"),TEXT(A1,"00000"))
all in one line, of course. Then copy down.

To update the list, change column A. Then you can hide column A and click
on column B.

 

[Big UT Fan]

I realized this was one way to do it but having duplicate columns isn't very
elegant. Just hoping to see if there was a way to do what I'd like to do.

Thanks, Mike