¥»©«³Ì«á¥Ñ av8d ©ó 2023-10-15 19:05 ½s¿è
- For i = 2 To 21
- If Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 3) <> "" Then
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 7, 3) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 4)
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 7, 4) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 16)
- End If
- Next
- For i = 22 To 41
- If Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 3) <> "" Then
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 9, 3) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 4)
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 9, 4) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 16)
- End If
- Next
- For i = 42 To 61
- If Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 3) <> "" Then
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 11, 3) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 4)
- Workbooks("±¾¸¹.xls").Sheets(1).Cells(i + 11, 4) = Workbooks("¤â¥U2.xls").Sheets(1).Cells(i, 16)
- End If
- Next
½Æ»s¥N½X 10/15 19:05 «·s¼¶¼g
°j°éi¦@¦³300¦C¡A½Ð°Ý«e½ú¬O§_¯à¦³¤ñ¸û²µuªº¼gªk¡AÁÂÁ¡I |