- ©«¤l
- 7
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 17
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- TAIPEI
- µù¥U®É¶¡
- 2012-3-31
- ³Ì«áµn¿ý
- 2012-4-21
|
[µo°Ý] ½Ð°Ý¦U¦ìVAB¤ÎEXCEL°ª¤â¦³Ãö¨â¬¡¶Ã¯¥~³¡°Ñ·Ó¤§°ÝÃD
½Ð°Ý¦U¦ìVAB¤ÎEXCEL°ª¤â
¤p¤k¤l¦³¨âÓ¬¡¶Ã¯ÀÉ®×a.xls ¤Î b.xls
¤p¤k¤l·QnÅý¬¡¶Ã¯a.xls¤§ sheet1ªºA5:J4000Àx¦s®æ¦U§O³sµ²¨ì
¬¡¶Ã¯b.xls¤§ sheet2ªºA5:J4000¤§¦U§OÀx¦s®æ
¤]´N¬O
¬¡¶Ã¯a.xls¤§ sheet1ªºA5 = ¬¡¶Ã¯b.xls¤§ sheet2ªºA5
¬¡¶Ã¯a.xls¤§ sheet1ªºA6 = ¬¡¶Ã¯b.xls¤§ sheet2ªºA6
...............¥H¦¹Ãþ±À¦Ü
¬¡¶Ã¯a.xls¤§ sheet1ªºJ4000=¬¡¶Ã¯b.xls¤§sheet2ªºJ4000
¥B·íקﬡ¶Ã¯a.xls¤§sheet1ªºA5:J4000¥ô¤@Àx¦s®æ
«h¬¡¶Ã¯b.xls¤§ sheet2ªºA5:J4000¬Û¹ïÀ³¦ì¸m¤§Àx¦s®æ¤]·|¦Û°Ê¸òµÛÅÜ°Ê
¨Ò¦p
a.xls¤§ sheet1ªºC100Àx¦s®æ¿é¤J 8888 «h
b.xls¤§ sheet2ªºC100Àx¦s®æ¿é¤J ¤]·|¦Û°Ê¥X²{8888
¤p¤k¤l¥Î¤F¤@Ӳ¤èªk´N¬O
1.¦P®É¶}±Ò¨âÓexcelÀÉ.( a.xls=¨Ó·½ÀÉ, b.xls =¥ØªºÀÉ)
2.°²³]b.xls¤§sheet2ªºB5n©Ma.xls¤§sheet1ªºB5¤@¼Ë,¥ý¦bb.xls¤§sheet2
ªºB5¿é¤J = ,¦A¤Á´«¨ìa.xls¤§sheet1,·Æ¹««ü¦Va.xls¤§sheet1ªºB5±µµÛ
ÂIÀ»·Æ¹«¥kÁä
3.³Ì«á«ö¤UEnter§Y§¹¦¨
¦ý¦¹°µªk¥²¶·¤@Ó¤@ÓÀx¦s®æ¥h§¹¦¨,µLªk¥ý°µ¤@Ó½d¨ÒÀx¦s®æ¦A¥Î©ì¦²ªº¤è¦¡¨Ó§¹¦¨¨ä¾lÀx¦s®æ,
¦]¬°¨ä¤½¦¡¬°b.xls¤§sheet2ªºB5='[a.xls] sheet1'!$B$5Y¥Î©ì¦²¤è¦¡«hb.xls¤§sheet2¤§©Ò¦³Àx¦s
®æ·|¬Ò='[a.xls] sheet1'!$B$5,³o¨SÃö«Y,¤p¤k¤l¥»·Q©ì¦²§¹«á,¦A¤@¤@¨ÓקïÀx¦s®æ¦ì¸m,¦ý«oµo²{¤£
¯àÂI¤J¤½¦¡Äæ¥hקï,¥un¤@ÂI¤J¤½¦¡Äæ,´Nºâ¤£§ó§ï¥ô¦óªF¦è,«öENTER¸õ¥X«á,¤½¦¡·|¦Û°ÊÂର¤å¦r
ÀÉ,¯u¶Ë¸£µ¬!
Y·Ó¤Wz¤§²Â¤èªk,Á`¦@40000ÓÀx¦s®æ¼¥H»ÝÂIÀ»·Æ¹«¦¸¼Æ,¤p¤k¤lªº¥k¤â¤âµÃ
¤ÎÂù²´®£±N¤£«O
¨D¦U¦ìVBA¤j«L¤ÎEXCEL°ª¤â
¯à§_¤jµo·O´d,±Ï¤@±Ï¤p¤k¤l¥i¼¦ªº¥k¤â¤âµÃ¤ÎÂù²´§a!:'(
¤p¤k¤l YUPOPO¯d |
|