½Ð±Ð¦U¦ì¥ý¶i~
¥Ø«e¦³¨âÓSHEET
·Qn§â¨C¤éªº¸ê®Æ½Æ»s¦Ü ¤é²Ö¿n³øªí
[¨C¤é¸ê®Æ]
[¤é²Ö¿n]
¥Ñ©ó¥Ø«e¬O§â¨C¤é¸ê®Æ³v¦æ±a¤J¤é²Ö¿n³øªí¤¤
·Q½Ð°Ýn¦p¦ó×¥¿»yªk¤~¯à¦Û°ÊŪ[¨C¤é¸ê®Æ]¦³´X¦æ
½Æ»s¨ì[¤é²Ö¿n]¦³¸ê®Æªº¤U¤@¦æ
¤p©f¥Ø«e»yªk- Sub TEST()
- Dim a, b, c, today
- Dim i As String
- i = Sheets("¤é²Ö¿n").Range("A65536").End(xlUp).Row 'pºâ¦³¸ê®Æ³Ì«á¤@¦C¤§¦C¼Æ
- j = Sheets("¤éÀË®Ö").Range("A65536").End(xlUp).Row
- '¤ñ¹ï¤é´Á
- If Worksheets("¤é²Ö¿n").Cells(i, 1).Value = Sheets("¤éÀË®Ö").Range("J2") Then MsgBox "¦¤w¦s¹L¸ê®Æ¡I"
-
- If Worksheets("¤é²Ö¿n").Cells(i, 1).Value <> Sheets("¤éÀË®Ö").Range("J2") Then
-
- For a = 1 To j - 1
- '¤é´Á¶×¥X
- Sheets("¤é²Ö¿n").Cells(i + a, 1).Value = Sheets("¤éÀË®Ö").Range("J2")
- '³o¸Ì¬O·Qn×¥¿ªº¦a¤è ¦]¤éÀˮָê®Æ¦³®É¦h¦³®É¤Ö ¤£¯à¼g¦º
- Sheets("¤é²Ö¿n").Range(Cells(i + 1, 2), Cells(i + 1, 8)) = Sheets("¤éÀË®Ö").Range("A2:G2").Value
- Sheets("¤é²Ö¿n").Range(Cells(i + 2, 2), Cells(i + 2, 8)) = Sheets("¤éÀË®Ö").Range("A3:G3").Value
- Sheets("¤é²Ö¿n").Range(Cells(i + 3, 2), Cells(i + 3, 8)) = Sheets("¤éÀË®Ö").Range("A4:G4").Value
- Sheets("¤é²Ö¿n").Range(Cells(i + 4, 2), Cells(i + 4, 8)) = Sheets("¤éÀË®Ö").Range("A5:G5").Value
-
- Next a
- MsgBox "¸ê®Æ¶×¥X§¹¦¨¡I" ' ¶×¥X§¹¦¨°T®§
- End If
- End Sub
½Æ»s¥N½X ³Â·Ð¤F~
¬¡¶Ã¯0118.zip (386.27 KB)
|