Is this possible? (Circular reference?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
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
 
Back
Top