ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤£¦PÀx¦s®æ¤ºªº¶W³sµ²¸Ó¦p¦ó¦P¨B

[µo°Ý] ¤£¦PÀx¦s®æ¤ºªº¶W³sµ²¸Ó¦p¦ó¦P¨B

½Ð°Ý¸Õºâªí¨â­Ó¤£¦Psheet(shee1¤Îsheet2)¤Wªº¶W³sµ²¤å¦r¸Ó¦p¦ó¦P¨B?
½Ð°Ñªþ¥ó¡C

·Ð½Ð°ª¤â¨ó§U¤p§Ì¸Ñ´b¡AÁÂÁÂ!

Àx¦s®æ¤ºªº¶W³sµ²¦p¦ó¦P¨B²¾Âà¨ì¥t¤@­Ósheet.rar (28.55 KB)

¦ó¿×"¦P¨B"???

TOP

¦ó¿×"¦P¨B"???
­ã´£³¡ªL µoªí©ó 2016-10-30 11:10


³ø§i­ã´£³¡ªL ª©¥D

¦P¨B:¬O«ü­ì¥»¦³¶W³sµ²¤å¦r¡A¥iÂI¿ï«á³s½u¤Wºô¡A¦Ó¦P®É¤]§Æ±æ¦b¤£¦PÀx¦s®æŪ¨ú¤U¡A¤]¤@¼Ë¥iÂI¿ï¤Wºô¡C

TOP

¦^´_ 3# klor

Sheet1!B7¶W³sµ²¤å¦r
Sheet2!B7­n§ìSheet1!B7¶W³sµ²¤å¦r

¥Ø«eµL¤º©w¨ç¼Æ¥i¥H¨Ï¥Î¡A¥i¥H°Ñ¦Ò¦¹½g»¡©ú http://forum.twbts.com/viewthrea ... eD1&ordertype=1

Sheet2!B7¤½¦¡¦p¤U
=HYPERLINK(link_location(Sheet1!B7),Sheet1!B7)


¦Û­q¨ç¼Æ
Function link_location(Rng As Range) As String
    link_location = Rng.Hyperlinks(1).Address
End Function

Àx¦s®æ¤ºªº¶W³sµ²¦p¦ó¦P¨B²¾Âà¨ì¥t¤@­Ósheet.rar (17.94 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089

ML089 ¤j¤j ¤Ó·PÁ±z¤F!

À°§Ú¸Ñ¨M³oÃøÃD¡C

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD