Excel範圍參照或複製(贈送22點):－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

Don't wait in line!

Buy your movie tickets online. Find reviews, trailers, and more at Fandango.

From our sponsors

Excel範圍參照或複製(贈送22點)

Dec 25th 2013, 03:22

請教一個excel的問題..

我有三個表sheet1~sheet3

我想讓 sheet2, sheet3的 H11:J13 都去抓sheet1的A1:C3來填入,
請問公式要怎麼下?.. 以下是不同狀況的需要:
1.sheet2, sheet3只要填入值
2.不只是填入值, 而是要把sheet1的超連結和註解及格式都填入
3.如果有新的sheet, 是否可能讓sheet1的A1:C3自動填入或按一個鈕填入到新sheet的H11:J13

我用的是excel 2003.. 非常感謝...
最佳解答者我個人送20點+2贊助

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.

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