Hsieh

¸ê®Æ®w³¡¥÷¤£²Å¦X¸ê®Æ®w³W«h
³o¼Ë¦hÀÉ®×Â^¨ú¸ê®Æ¡A¥Î¤½¦¡³sµ²¬O«D±`¤£´¼¤§Á|
³o¼Ëªº°ÝÃD¥i¨Ï¥ÎVBA»²§U

Hsieh

¦^´_ 15# daniel91276

³o¤£¬O§A­n¤èªk¨ú±Ëªº°ÝÃD
°ò¥»¤W¨ç¼Æ­n®e©ö°µ¨ìªº¸Ü¡A§Aªº¸ê®Æ¥²¶·²Å¦X¸ê®Æ®w«Ø¥ß³W«h
¤£¨Ï¥Î¦X¨ÖÀx¦s®æ¡A¨C¦C°O¿ý¤@µ§¸ê®Æ¡A¯Á¤Þ©ú½T
§Aªºªí®æ¨S¤@¼Ë²Å¦X¡A­n¥Î¨ç¼Æ©ÎEXCEL¤º«Ø¥\¯à¨Ó§¹¦¨
Ãø«×³£»·¤ñVBA¨Óªº°ª
§Ú¨Ã«D»¡«D±o¨Ï¥ÎVBA¡A­Y­n´î¤Ö³Â·Ð³Ì­«­nÁÙ¬O«Ø¥ß¸ê®Æªí®É¦h¤UÂI¥\¤Ò

Hsieh

¦^´_ 18# daniel91276
¬JµM±z¦p¦¹°í«ù
¿ï¨úC6Àx¦s®æ
©w¸q¦WºÙ
a=MOD(ROW(),3)
x=OFFSET(B!$C6,-MOD(ROW(),3),-2)
y=B!C$4
z=y&x
¥´¶}©Ò¦³¬¡­¶Ã¯903.xls~912.xls
TEST.xls
C6=IF(ISERROR(MATCH(z,INDIRECT("["&y&".xls]B!$A:$A"),0)),"",INDEX(INDIRECT("["&y&".xls]B!$C:$C"),MATCH(z,INDIRECT("["&y&".xls]B!$A:$A"),0)+a,))
¦V¥k¦V¤U½Æ»s

¤U¸ü (65.83 KB)

2011-3-17 19:32

Hsieh

¦^´_ 20# daniel91276
A4¶ñ¤J©m¦W
¥[¤J©w¸q¦WºÙ
n=MATCH(B!$A$4,INDIRECT("["&y&".xls]B!$4:$4"),0)
C6=IF(ISERROR(MATCH(z,INDIRECT("["&y&".xls]B!$A:$A"),0)),"",INDEX(INDIRECT("["&y&".xls]B!R1C"&n&":R65536C"&n,0),MATCH(z,INDIRECT("["&y&".xls]B!$A:$A"),0)+a,))

¤U¸ü (20.94 KB)

2011-3-18 21:53