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

[µo°Ý] ¦h­¶¤u§@ªí¬D¥X²Å¦X¸ê®æ·J¾ã¨ì·sªº¤u§@­¶

[µo°Ý] ¦h­¶¤u§@ªí¬D¥X²Å¦X¸ê®æ·J¾ã¨ì·sªº¤u§@­¶

¦p½d¨Òªí®æ
½d¦C¤¤ ¦³¦h­Ó¤À­¶  §Ú·Q¦bÁ`ªí§Ë¤@­Ó¥i¥H¬d¸ß¬Y¤é ¯à¬D¥X²Å¦X°T¸¹ªº¤À­¶¤u§@ªí  ·J¾ã¨ìÁ`ªí
½Ð°Ý¸Ó¦p¦ó°µ
²M°ª ¯Ü®zªº°°¹¢

k1=IF($J1="","",IF(INDIRECT($J1&"!"&CHAR(64+COLUMN(I1))&MATCH(TEXT(A$2,"yyyy/mm/dd"),INDIRECT($J1&"!A:A"),0))="ªÅ","ªÅ",""))

­×§ï¦¨³o¼Ë´N¥i¥H¤F
²×©ó§¹¦¨¤F
ÁÂÁª©¤j«ü¾É
²M°ª ¯Ü®zªº°°¹¢

TOP

¥Î15¼Óªº¤èªk¥þ³¡§ï¦¨¤é´Á®æ¦¡¡C¸Õ¸Õ¡C
¸ê®ÆÀ³¬Ocopy¨Óªº¡A¬O¤å¦r¼Ò¦¡,¤é´Á¥Î¤â°Ê¿é¤J¬O¤é´Á®æ¦¡¡C­Y©È³Â·Ð¥i§âÁ`ªíAÄæ§ï¦¨¤å¦r¼Ò¦¡¤]¥i¥H¡C

TOP

½d¨Ò3.rar (87.61 KB)
·PÁª©¥D «ü¾É:victory:
¥i¥Ñ¤é´Á¥s¥X¸ê®Æ¤F
¥Ø«e³Ñ¤U³Ì«á¤@­Ó°ÝÃD¤F
­è§Ú´ú¸Õ®É   §Ú­Yª½±µ±N1101¤ºªº¤é´Á copy¶K¨ìÁ`ªí¤é´ÁÄæ¦ì®É   ¥i¥H°õ¦æ
¦ý  ­Y¤â°Ê¦bÁ`ªíªº¤é´ÁÄæ¦ì    §ï¤é´Á´N      µLªk°õ¦æ
²M°ª ¯Ü®zªº°°¹¢

TOP

k1=IF($J1="","",IF(INDIRECT($J1&"!i"&MATCH(A$2,INDIRECT(J1&"!a:a"),))="ªÅ","ªÅ",""))

TOP


½Ð±Ðª©¥D
§Ú§â¤é´Á§R°£  ½T¥i¥H¯d¤U¸ê®Æ  
µM¦Ó  §Ú¥u­n¦b
k=IF($J1="","",IF(INDIRECT($J1&"!"&CHAR(64+COLUMN(I1))&"253")="ªÅ","ªÅ",""))
§â253  §ó§ï252©Î251  ¸ê®Æ«K·|§ó§ï¤F
¨º»ò³o¼Ë¬Ý¨Ó  ¦n¹³¤é´Á¨ºÄæ¦ì  µL®Ä
¨S¿ìªk¥Ñ¤é´Á¨Ó¹ïÀ³¨ì·í¤éªº¸ê®ÆÄæ¦ì
²M°ª ¯Ü®zªº°°¹¢

TOP

AÄæ¤é´Á¬Ý¦ü¤é´Á¡A¹ê»Ú¬O¤å¦r¼Ò¦¡¡C
¿ïAÄæ¡C¦A¥Î¸ê®Æ­åªR¡CÄæ¦ì¸ê®Æ®æ¦¡¿ï¤é´ÁªºYMD¡C
©Î¦b¥ô¤@Àx¦s®æ¿é¤J1¡A=> COPY =>¿ïAÄæ=>¥kÁä=>¿ï¾Ü©Ê¶K¤W=>­¼¡C¦A³]¦¨¤é´Á®æ¦¡¡C

TOP

¬ã¨s¤@¾ã±ß  ²×©óª¾¹D§Ú­þÃä¿ù¤F
¶K¤W¤½¦¡®É" {}"  ­n¥ý¥h±¼  µM«á«öCtrl+Shift+Enter  ´N·|¦Û°Ê²£¥Í
³o¼Ë§Ú´N§¹¥þ¥i¥H¿é¥X¸òªO¤j¶Kªº¹Ï¤ù¤@¼Ëªºµ²ªG¤F   «D±`·PÁÂ

ÁٽбЪO¤j  ¬°¦ó§Ú§ïÅܤé´Á«á  ¸ê®Æ³£¤£·|ÅÜ°Ê
¬O§Úªº¤é´Á®æ¦¡¿ù»~ÁÙ¬O­þÃä¥X¿ù
²M°ª ¯Ü®zªº°°¹¢

TOP


©w¸q  ªí¦W  ok
¦ý tot ©w¸q§¹ ¨S¤ÏÀ³
¬O§Ú¥Îoffice 2003ªºÃö«Y¶Ü?
²M°ª ¯Ü®zªº°°¹¢

TOP

½Ð°Ý  ª©¤j
©w¸q¦WºÙ
§Ú¸Ó¥h­þ°µ³]©w
¯à§_½Ðª©¤j  ±NÀÉ®×±H¨ì§Úªº«H½c [email protected]
Åý§Ú°Ñ¦Ò¤@¤U  §Ú¦b©w¸q¦WºÙ¨ºÃä¬Ý¤£À´
²M°ª ¯Ü®zªº°°¹¢

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD