- ©«¤l
- 550
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 614
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-4-23
|
¦^´_ 13# waterfox
³o¬O§Ú¤W¸üÀɮפ¤ªºµ{¦¡½X~- Private Sub CommandButton1_Click() '¸ê®Æ©ßÂà
- '======== A =>¨C¤@¦C¶]ªº¦¸¼Æ ====================
- A = Sheet4.Range("IV2").End(xlToLeft).Column
- A = (A - 4) / 3
- If A - Int(A) > 0 Then
- MsgBox "¸ê®ÆÄæ¦ì¦³»~"
- Exit Sub
- End If
- A = A - 1
- '======== B => Á`¦@n¶]ªºµ§¼Æ ====================
- B = Sheet4.Range("A65536").End(xlUp).Row
- For I = 3 To B
- Set C = Sheet2.Columns("B:B").Find(Sheet4.Range("B" & I))
-
- If Not C Is Nothing Then
- C = Sheet2.Columns("B:B").Find(Sheet4.Range("B" & I)).Row
- For J = 0 To A '(EX. 0->11 =12¦¸)
- D = Sheet4.Cells(I, 7 + J * 3)
- If D = "" Then
- Else
- Do Until Sheet2.Range("F" & C + K) = ""
- If Sheet2.Range("F" & C + K) = D Then
- If Sheet4.Cells(I, 5 + J * 3) > 0 Then
- Sheet2.Cells(C + K, 7 + J) = Sheet4.Cells(I, 5 + J * 3)
- End If
- If Sheet4.Cells(I, 6 + J * 3) > 0 Then
- Sheet2.Cells(C + K, 21 + J) = Sheet4.Cells(I, 6 + J * 3)
- End If
- P = 1
- Exit Do
- End If
- K = K + 1
- Loop
- If P = 0 Then
- Sheet2.Rows(C + K).Insert Shift:=xlDown
- Sheet2.Range("F" & C + K) = Sheet4.Cells(I, 7 + J * 3)
- If Sheet4.Cells(I, 5 + J * 3) > 0 Then
- Sheet2.Cells(C + K, 7 + J) = Sheet4.Cells(I, 5 + J * 3)
- End If
- If Sheet4.Cells(I, 6 + J * 3) > 0 Then
- Sheet2.Cells(C + K, 21 + J) = Sheet4.Cells(I, 6 + J * 3)
- End If
- End If
- End If
- K = 0
- P = 0
- Next
- End If
- Next
- End Sub
½Æ»s¥N½X |
|