|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 27th, 2006, 06:53 AM
posted to microsoft.public.excel.links
|
|||
|
|||
copying links in excel
is it possible to create a hyperlink to another sheet in a workbook with an
absolute column and a relative row refrence? And can it be copied down a column without having to edit it for each row? 
|
|
#2
March 23rd, 2007, 08:01 AM
posted to microsoft.public.excel.links
|
|||
|
|||
|
Area Code And Zip code Of China City - China City Guide
Beijing
Area postalcode Tel Code Area Postalcode Tel Code Beijing 100000 010 Tong County 101100 010 Pinggu County 101200 010 Shunyi County 101300 010 Huanrou County 101400 010 MIyun County 101500 010 Yanqing County 102100 010 Changping County 102200 010 Mentougou District 102300 010 FangshanDistrict 102400 010 Yanshan District 102500 010 Daxing County 102600 010 Shanghai Area postalcode Tel Code ¡¡ Area postalcode Tel Code Shanghai 200000 021 Jinjiao District 200100 021 shanghai County 201100 021 Chuansha County 201200 021 Nanhui County 201300 021 Fengxian County 201400 021 Jinshan County 201500 021 Songjiang County 201600 021 Qingqu County 201700 021 Jiading County 201800 021 Baoshan County 201900 021 Chongming County 202100 021 County 202204 ¡¡ ¡¡ ¡¡ ¡¡ Tianjin Area postalcode Tel Code Area postalcode Tel Code Tianjin 300000 022 Tanggu 300450 ¡¡ Hangu 300480 ¡¡ ninghe District 301500 022 Jinghai County 301600 022 Wuqing District 301700 022 Baodi County 301800 022 County 301900 022 Dagang District 300270 ¡¡ ¡¡ ¡¡ ¡¡ Inner Mongolia Area Postalcode Tel Code Area Postalcode Tel Code Huolinguole 029200 0485 Jining 012000 0474 Zalaidui 162600 0472 Baotou 014000 0472 Linhe 015000 0478 Wuhai 016000 0473 Dongsheng 017000 0477 Tongliao 028000 0475 Chifeng 024000 0476 Yakeshi 022100 0471 Shanxi Province Area Postalcode Tel Code Area Postalcode Tel Code Taiyuan 030000 0351 Yuci 030600 0354 xinzhou 034000 0350 Datong 037000 0352 Linfen 041000 0357 Houma 043000 0365 Yunchang 044000 0359 Yangquan 045000 0353 Changzhi 046000 0355 Jincheng 048000 0356 Hebei Province Area Postalcode Tel Code Area Postalcode Tel Code Shijiazhuang 050000 0311 nangong 051800 0327 Xinji 052300 0315 Hengshui 053000 0318 Xingtai 054000 0319 Shahe 054101 0319 Handan 056000 0310 Cangzhou 061000 0317 Botou 062100 0339 Renqiu 062500 0326 Tangshan 063000 0315 Qinghuangdao 066000 0335 Beidai 066100 ¡¡ Chengde 067000 0314 Baoding 071000 0312 Zhuozhou 072700 0323 Dingzhou 073000 0324 Zhangjiakou 075000 0313 Langdan 102800 0316 ¡¡ ¡¡ ¡¡ ........ http://www.china-tour.cn/Area_Code/A...de_Zipcode.htm
|
|
#3
June 16th, 2007, 05:39 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
copying links in excel
Hi June:
something like: =HYPERLINK("#"&CELL("address",Sheet3!$Z100),"targe t") if copied down will produce: =HYPERLINK("#"&CELL("address",Sheet3!$Z100),"targe t") =HYPERLINK("#"&CELL("address",Sheet3!$Z101),"targe t") =HYPERLINK("#"&CELL("address",Sheet3!$Z102),"targe t") =HYPERLINK("#"&CELL("address",Sheet3!$Z103),"targe t") so the row reference adjusts automatically without editting -- Gary''s Student - gsnu200730 "june.sidwell" wrote: is it possible to create a hyperlink to another sheet in a workbook with an absolute column and a relative row refrence? And can it be copied down a column without having to edit it for each row?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
