Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible? (Circular reference?)
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible? (Circular reference?)
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible? (Circular reference?)
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 "MyVeryOwnSelf" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Reference | Excel Discussion (Misc queries) | |||
'circular reference' | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Worksheet Functions | |||
Circular Reference??? | New Users to Excel | |||
how to: circular reference | Excel Worksheet Functions |