close
Blogtrottr
Mobile01最新文章
 
Design your online store.

Shopify let's you create your online store easily. With total control over your website’s design, state-of-the-art security & a fully hosted online shopping cart.
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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 yuahong3 的頭像
    yuahong3

    line跑跑薑餅人外掛, line跑跑薑餅人電腦版下載, line 跑跑薑餅人 修改, line跑跑薑餅人攻略, line跑跑薑餅人 八門修改

    yuahong3 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄