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

[µo°Ý] ¦Û©w¸q¦WºÙ

[µo°Ý] ¦Û©w¸q¦WºÙ

¦U¦ì¤j¤j¦n,

§Úªº¤u§@ªí1~31(¦WºÙ¥H¼Æ¦r©R¦W,¬O¨ú¨C¤Ñªº¤é´Á)³]©wªº®æ¦¡³£¬Û¦P,¥HM3:O20ªº½d³ò¨ú¦W:¥X³f°Ï,
ÁöµM§Ú¥Î¸s²Õ¤è¦¡§â1:31ªº¤u§@ªí³£¿ï¨ú,¦ýÂI¿ï¥X³f°Ï®É,¨ÃµLªkÀ³¥Î¦b¨C¤@­Ó¤u§@ªí,¥u·|¥X²{¦b²Ä¤@­Ó,
½Ð°Ý­n«ç»ò¾Þ§@,¤~¯àÅý1:31ªº¤u§@ªí¥Î¦P¤@­Ó¦Û©w×m¦WºÙ?

¤@¯ë¤½¦¡¦WºÙ
³]©w
=$A$1:$D$10
·|¦Û°ÊÅܦ¨
=Sheet1!$A$1:$D$10
¥u¾A¥Î©ó¸Ó¤u§@ªí

­Y¨C­Ó¤u§@ªí³£»Ý­n³]©w¬Û¦Pªº¦WºÙ®É¡A­×§ï¦p¤U
=!$A$1:$D$10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

±z¦n,
§Ú¨Ì³o­Ó¤èªk©w¸q¤F,¦ý¤U©Ô¥ª¤W¨¤«o¬Ý¤£¨ì©w¸q¦WºÙ,¥i¥HÀ°§Ú¬Ý¤U¶Ü?
20190429.134909_¦WºÙºÞ²z­û.jpg
2019-4-29 13:56


20190429.134944_¤U©Ô.jpg
2019-4-29 13:57

TOP

¦^´_ 3# PJChen

¤ñ¸û¹³¦Û­q¨ç¼Æ¡A§A¥i¥H¿é¤J¤½¦¡®É§ä¨ì¥¦¡A

¨Ò¦p ¦WºÙ AA =!$A$1:$$C$3

D1¿é¤J =SUM( «öA´N·|¥X²{ AA´¡¤J¤½¦¡¡A©Îª½±µ¿é¤J¤]¥i¥H)
=SUM(AA)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089

½Ð°Ý¤j¤j,

§Ú­ì¥»ªº¥Î·N¬O·Q­nÀ³¥Î¦Û­q¸q·í¦¨¤@­Ó¬¡°Êªº½d³ò,¦]¬°§Y¨Ï½d³ò¦³ÅÜ°Ê,­ì¥»ªºVBA¨Ã¤£»Ý­n¥h§ó§ï,´N¥i¥H§ä¨ì©Ò»Ý­nªº½d³ò,
¨Ò¦p:¨Ó·½Àɪº¦Û­q¸q¬O"BF.ªL¤f¥þ¥x",¥ØªºÀɪº¦Û­q¸q¬O"¥X³f",¨C¤Ñ³£­ncopy ¸ê®Æ¶K¨ì·í¤Ñ¥X³fªº¤é´Á¤u§@ªí¤¤,
¥i¥H¥Î¥H¤UVBA¥h§@·~,¦]¬°­n¶Kªº¸ê®Æ«Ü¦h,¨C¤Ñ³£¤@¼Ò¤@¼Ëªº°Ê§@,¥i¥H¸`¬Ù¤@¨Ç®É¶¡,©Ò¥H¦Û­q¸q§Ú¬O·Q¥Î¦b³o¤è­±ªº,
·Q½Ð°Ý¹ï©ó§Ú·Q­nªº»Ý¨D,¬O¤£¬O¦³¨ä¥¦¤èªk¥i¥H¸Ñ¨M?
  1.     Windows("²z³f³æ_All.xlsx").Activate
  2.     Application.Goto Reference:="BF.ªL¤f¥þ¥x"
  3.     Selection.Copy
  4.     Windows("NEW¤ñµá¦hªL¤f²z³fªí108  4¤ë.xls").Activate
  5.     Application.Goto Reference:="¥X³f"
  6.     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  7.         :=False, Transpose:=False
½Æ»s¥N½X

TOP

¦^´_ 5# PJChen

À³¸Ó¦bÁ`ªíªºÀx¦s®æ«Ø¥ß­n§ìªºÀɮצWºÙ¤Î¸ê®Æ½d³ò
³o¼Ë¤ñ¸û©ú½T
   
ÀɮצWºÙ¡A¸ê®Æ½d³ò¡A¬O§_°õ¦æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD