·Q½Ð±Ð¦³ÃöEXCEL: Sheet1¸ê®Æ,¦p¦ó¦Û°Ê±a¥X¦bSheet2ªº¤U¤@¦Cªº°ÝÃD
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
sheet1!a2
=offset(sheet2!a$1,counta(sheet2!$aa)-1,)¥k©Ô
gong µoªí©ó 2011-8-31 11:22
gong«e½ú±z¦n,¸Õ¥Î±z¤Wzªº¤èªk,sheet1!a2=offset(sheet2!a$1,counta(sheet2!$aa)-1,)¥k©Ô , µ²ªG¬°"0" ,¤£ª¾¹Dþ¸Ì¦³»~??ÁÂÁÂ... |
|
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¦^´_ James-001
Hsieh µoªí©ó 2011-8-31 11:16
Hsieh «e½ú±z¦n,§Ú¦³¸ÕµÛ¥Î±z¤WzªºVBA½s¿è¤F¤@¤U,¦ý¬O¥i¯à§Ú±q¨Ó¨S¾Ç¹LVBA,©Ò¥H¸Õ¤£¥X¨Ó!
·Q½Ð«e½ú¥i¥H¤@¨BÆJ¤@¨BÆJ¦a±Ð¾Ç¥Í¤p§Ì,·PÁ±zªº@¤ß,ÁÂÁÂ!! |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
=offset(sheet2!a$1,counta(sheet2!$a:$a)-1,)
»P§A¶Kªº
=offset(sheet2!a$1,counta(sheet2!$aa)-1,)
¬õ¦â¦a¤è¤£¦P,§A¦A¸Õ¸Õ
ÁÙ¦³½Ðªþ¤WÀÉ®×,«K©ó¹ï¦ì¸m |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¦^´_ 13# Hsieh
Hsieh «e½ú±z¦n,§Ú¦³¥Î±z¤WzªºVBA±Ð¾Ç,¤w¸g¦³¦¨¥\¹F¨ì¹wpªº®ÄªG¤F!!·PÁ±zªº@¤ß«ü¾É!!
¤§«á,½s¼g¦Û¤vªº¥¨¶°,¦pªG¹J¨ì°ÝÃD,¦A½Ð«e½ú«üÂI!! ÁÂÁ : ] |
|
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
=offset(sheet2!a$1,counta(sheet2!$aa)-1,)
»P§A¶Kªº
=offset(sheet2!a$1,counta(sheet2!$aa)-1,)
...
gong µoªí©ó 2011-8-31 17:58
gong «e½ú±z¦n!§Ú¦³§âÀÉ®×¥I¥óµ¹±z,½Ð±z¬Ý¬Ý³o¼Ë¹ï¤£¹ï?!
ÀÉ®×-1.rar (2.65 KB)
|
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¬O§Úªº¿ù
§A¬O·Q±NSHEET1¿é¤Jª½±µÂ\¨ìSHEET2
§Úªº°µªk¬O¦bSHEET1¤¤§äSHEET2ªº¸ê®Æ
·N«ä§¹¥þ¤£¦P,¨Ì§Aªº»Ý¨D
1.¥ÎVBA°µ§a
2.§ó²³æªºªº¬Oª½±µ¦bSHEET2¤¤¿é¤J,¦pªG¬O³o¼Ë´N¤£¥Î°Ý¤F
©Ò¥Hµ²½×±Ä¥Î1 |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¬O§Úªº¿ù
§A¬O·Q±NSHEET1¿é¤Jª½±µÂ\¨ìSHEET2
§Úªº°µªk¬O¦bSHEET1¤¤§äSHEET2ªº¸ê®Æ
·N«ä§¹¥þ¤£¦P,¨Ì§Aªº ...
gong µoªí©ó 2011-9-1 13:02
·PÁÂgong«e½úªº«üÂI,¾Ç¥Í¤p§Ì¨ü±Ð¤F,·P®¦!! |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 54
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2013-11-15
|
§Ú¸ÕµÛ2¼Ó¥ÎVLOOKUPÀ³¸Ó¨S¦³°ÝÃD.
=VLOOKUP(A2,¤u§@ªí1!A:B,2,0)
¦Ó¥B«Ü²³æ |
|
|
|
|
|
|
- ©«¤l
- 119
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 138
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-6
- ³Ì«áµn¿ý
- 2019-5-4
|
Hsieh«e½ú:
sheet1¸ê®Æ¦¨¥\Âಾ¦Üsheet2¡A¦ýYn²M°£sheet1ªº¸ê®Æ¡A¸Ó¦p¦ó¶i¦æ¡A¬O¨Ï¥Îclear¶Ü?
·PÁÂ |
|
|
|
|
|
|