Sub Macro1()
Dim X As Long
Sheets(1).Select
If Range("c1") = 14 Then
Sheets(2).Select
X = Range("A65536").End(xlUp).Row + 1
Sheets(1).Range("b2").Copy
Sheets(2).Cells(X, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets(1).Select
Range("B3:B15").Select
Selection.Copy
Sheets(2).Select
Cells(X, 2).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets(1).Select
Range("B3:B8").ClearContents
Range("B9:B15").ClearContents
Range("B3").Select
Else
MsgBox ("数据未填写完整,请确认!")
End If
End Sub