'方法思路:.判断表1A列的值=表2c列的值,则表1c列值赋值到表2i列,表1d列值赋值到表2h列。
aarow = 9 '
bbrow = 12
num = 0
For i = 1 To aarow
For j = 2 To bbrow
If (Sheets("Sheet1").Range("a" & i).Value = Sheets("2015.1").Range("c" & j).Value) Then
Sheets("2015.1").Range("i" & i).Value = Sheets("Sheet1").Range("c" & i).Value
Sheets("2015.1").Range("h" & i).Value = Sheets("Sheet1").Range("d" & i).Value
num = num + 1
End If