- ©«¤l
- 45
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2018-2-12
- ³Ì«áµn¿ý
- 2024-3-9
|
[µo°Ý] for ±_ª¬°j°é ¹Bºâ³t«×¦³ÂI¤[½Ð°Ý¸Ó¦p¦ó§ïµ½
- Sub ¾P³f©ú²ÓÁ`¼Æ()
- Dim x As Long
- With ¾P³fÁ`¼Æ
- For i = 5 To 64
- For c = 10 To 39
- x = WorksheetFunction.sumif(Sheets("¾P³f©ú²Ó").Range("B2:B500"), Sheets("¾P³fÁ`¼Æ").Cells(1, c) & Sheets("¾P³fÁ`¼Æ").Cells(i, 1), Sheets("¾P³f©ú²Ó").Range("O2:O600"))
- If Sheets("¾P³fÁ`¼Æ").Cells(i, c) <> x Then
- Sheets("¾P³fÁ`¼Æ").Cells(i, c) = x
- End If
- Next
- Next
- End With
-
- End Sub
½Æ»s¥N½X |
|