|
- Private Sub CommandButton1_Click()
- Set sh = Sheets("In")
- G2 = sh.[G2].Value
- OutCount = Sheets("Out").Range("A" & Rows.Count).End(xlUp).Row
- If OutCount > 5 Then
- OutData = Sheets("Out").Range("A6").Resize(OutCount - 5, 82).Value
- For j = 1 To UBound(OutData, 1)
- If OutData(j, 1) = G2 Then Exit For
- Next j
- If j = UBound(OutData, 1) + 1 Then GoTo Ins
- InData = sh.Range("F4:J18").Value
- Ti = Array("G2", "C1", "E1", "G1", "E2", "C2", "I1", "K1", "C3", "E3")
- For i = 1 To 82
- If i <= 10 Then
- sh.Range(Ti(i - 1)).Value = OutData(j, i)
- Else
- InData(Int((i - 11) / 5) + 1, (i - 11) Mod 5 + 1) = OutData(j, i)
- End If
- Next i
- sh.Range("F4:J18").Value = InData
- Else
- OutData = Sheets("Out").Range("A6").Resize(1, 82).Value
- Ins:
- InData = sh.Range("F4:J18").Value
- Ti = Array(G2, sh.[C1].Value, sh.[E1].Value, sh.[G1].Value, sh.[E2].Value, sh.[C2].Value, sh.[I1].Value, sh.[K1].Value, sh.[C3].Value, sh.[E3].Value)
- For i = 1 To 82
- If i <= 10 Then
- OutData(1, i) = Ti(i - 1)
- Else
- OutData(1, i) = InData(Int((i - 11) / 5) + 1, (i - 11) Mod 5 + 1)
- End If
- Next i
- Sheets("Out").Range("A" & OutCount + 1).Resize(1, 82).Value = OutData
- End If
- End Sub
复制代码 |
|