[EXCEL問題]如何設定才能使連結更新?:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Mobile01最新文章

Many wonderful memories are captured in black and white.

With digital photographs, the art is now in creating black and white images. This course will teach you how to use Photoshop techniques to create beautiful images.

From our sponsors

[EXCEL問題]如何設定才能使連結更新?

Aug 21st 2013, 08:27

按這裡檢視圖片

工作表1 的一、二、三分別設有連結到工作表2

[工作表1]
　一 =HYPERLINK("[活頁簿1.xlsx]工作表2!A1","一")
　二 =HYPERLINK("[活頁簿1.xlsx]工作表2!A5","二")
　三 =HYPERLINK("[活頁簿1.xlsx]工作表2!A8","三")

我想將工作表1的一、二、三分別連結到工作表2的一、二、三位置
想達成的目的是: 在工作表1點選"一"可直接連結到工作表2"一"的位置

問題來了
若有新增一筆資料(如上圖2→3所示)
[工作表2]　(圖2)
　一　　A1:A3
　二　　A5:A6　---->新增一列後
　三　　A8:A13

　　　　　(圖3)
　一　　A1:A3
　二　　A5:A7
　三　　A9:A14　---->往下移一列(A8移到A9)

因為表二新增一列了，所以表三的位置改變
該如何設定才能讓工作表1的連結跟著更新?

(應該看得懂吧哈哈)

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions