쥻§Q¥ÎFor...Next + IF §PÂ_¦¡±NSheet1.Cells(k, 2)ªºÈ¨Ì±ø¥óÂà¸m¦Ü¨ä¥LÄæ¦ì¡A¦ý¦]IFªº±ø¥ó¦¡Åܦ¨°ÊºA¡AY±N±ø¥ó¸ê®Æ©ñ¸mCÄæÀx¦s®æ¡A
½Ð±Ð¦p¦ó§Q¥ÎFor°j°é(CÄæ§PÂ_È)¨ú¥N쥻ªºIF §PÂ_¦¡¡A±N²Å¦X¸ê®Æ¨Ì§ÇÂà¸m¨ä¥LÄæ¦ì¡A¸Ô²Ó¸ê®Æ¦pªþ¥ó¡C«ÜÁÂÁ¤j®aªºÀ°¦£^^
Sub Macro1()
For k = 2 To Sheet1.[A65535].End(xlUp).Row
If Sheet1.Cells(k, 2) = "A" Then
Sheet1.Cells(k, 1).Copy _
Destination:=Sheet1.Range("D65536").End(xlUp).Offset(1)
End If
If Sheet1.Cells(k, 2) = "B" Then
Sheet1.Cells(k, 1).Copy _
Destination:=Sheet1.Range("E65536").End(xlUp).Offset(1)
End If
If Sheet1.Cells(k, 2) = "C" Then
Sheet1.Cells(k, 1).Copy _
Destination:=Sheet1.Range("F65536").End(xlUp).Offset(1)
End If
Next |