|
本帖最后由 kataa 于 2016-6-3 12:10 编辑
想要在M《仪器鉴定表》中根据C列的(仪器编号)自动填入D~I列的内容,需填入的内容都在《仪器位置统计表》,怎么做个VBA的代码能实现呢,希望高手帮忙看下,这个只是表格的一小部分,而且引用的表格里面有单行还有双行,所以比较麻烦
- Private Sub CommandButton1_Click()
- Dim wb, i%, j%
- Dim mypath$, myfile$
- Application.ScreenUpdating = False
- mypath = ThisWorkbook.Path & "/"
- myfile = Dir(mypath & "仪器安装位置.xls")
- Set wb = Workbooks.Open(mypath & myfile)
- With wb.Worksheets("Sheet1")
- For i = 4 To Range("c65536").End(xlUp).Row Step 2
- For j = 2 To .Range("c65536").End(xlUp).Row
- If Trim(Range("c" & i).Value) = Trim(.Range("c" & j).Value) Then
- Range("c" & i).Offset(0, 1).Value = .Range("c" & j).Offset(0, 1).Value
- Range("c" & i).Offset(0, 2).Value = .Range("c" & j).Offset(0, 2).Value
- Range("c" & i).Offset(0, 4).Value = .Range("c" & j).Offset(0, 3).Value
- Range("c" & i).Offset(0, 5).Value = .Range("c" & j).Offset(0, 4).Value
- Range("c" & i).Offset(0, 6).Value = .Range("c" & j).Offset(0, 5).Value
- End If
- Next
- Next
- End With
- wb.Close SaveChanges:=False
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|