Sub 企业信息排序整理() i = k = 2 ‘i 为“部件编号”表计数变量,k 为“部件-企业信息”表计数变量 For i = 2 To 81 j = 2 ’ j 为“企业信息”表计数变量 t = 1 ‘ t 为内层循环终止条件 Do If Worksheets("企业信息").Cells(j, 1) = Worksheets("部件编号").Cells(i, 2) Then Worksheets("部件-企业信息").Cells(k, 1) = Worksheets("部件编号").Cells(i, 1): Worksheets("部件-企业信息").Cells(k, 2) = Worksheets("部件编号").Cells(i, 2): Worksheets("部件-企业信息").Cells(k, 3) = Worksheets("企业信息").Cells(j, 2): Worksheets("部件-企业信息").Cells(k, 5) = Worksheets("企业信息").Cells(j, 3): Worksheets("部件-企业信息").Cells(k, 6) = Worksheets("企业信息").Cells(j, 4): Worksheets("部件-企业信息").Cells(k, 7) = Worksheets("企业信息").Cells(j, 5) End If j = j + 1 t = t + 1 k = k + 1 Loop Until t > 7 Next i End Sub