[june.sidwell]

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?

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

[Gary''s Student]

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?