1. ¦b [Sheet1] A2 ¿é¤J¹Ï¤ù¦WºÙ; ½Õ¾ãB2ªº¤j¤p©M¹Ï¤ù¤j¤p, ¤£Åý¹Ï¤ù¶W¥X¸Ó®æ;
2. «½Æ¨BÆJ 1 ¦b A3, A4, ....; B3, B4, .... ¿é¤J¦WºÙ©M´¡¤J¹Ï¤ù
3. ¿ï©wÀx¦s®æ[B2], «ö¤U½Æ»s«ö¶s(or ctrl+c), ¤Á´«¨ì[Sheet2], «ö¤U"¶K¤W"«ö¶s¤Uªº½bÀY, ¿ï¾Ü Linked Picture (¤¤¤åÀ³爲"³sµ²ªº¹Ï¤ù")
4. ¦b [sheet2]¤¤¿é¤J¤½¦¡, B1 =MATCH(A1, Sheet1!$A$2:$A$5,0); C1 =OFFSET(Sheet1!$B$1,Sheet2!$B$1,0)
<½Ðª`·N¤£n¼g¿ù¤½¦¡¤¤ªºSheet1! ©MSheet2!>
5. ¤Á´«¨ìFormulas "¤½¦¡"¶¦¸¤U, §ä¨ìDefine Name "©w¸q¦WºÙ" (¤¤¤å¦WºÙ¤£½T©w), ¦p¤U¹Ï
¦b c ¤¤¿é¤J¦WºÙ: "dyn_pick_pic" (¤£¥Î¿é¤J¤Þ¸¹)
¦b d ¤¤¿é¤J "=OFFSET(Sheet1!$B$1,Sheet2!$B$1,0)" (¤£¥Î¿é¤J¤Þ¸¹, ¥i¥H±qC1 ¤¤½Æ»s¤å¦r)
6. ¿ï©w¨BÆJ3¤¤¶K¤Wªº¹Ï¤ù, ¦b Formula Bar ¤¤¿é¤J ¨BÆJ5©w¸qªº¦WºÙ dyn_pick_pic
7. ¹Ï¤ù±N·|¨Ì[A1] ¦ÓÅܤÆ
ªþ¥ó
dyn_pick_pic_Sonny_Su.rar (326.88 KB)
¶È¦b Excel 2010 ´ú¸Õ¹L, ¨ä¥Lª©¥»¥¼ª¾. ½Ð´ú¸Õ¨ä¥Lª©¥»,¨Ã§iª¾. |