Andy2483

¦^´_ 1# °¨¾å«n

ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾ÇÂǦ¹©«½m²ßVBA°}¦C,¾Ç²ß¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò

Option Explicit
Sub TEST()
Dim K$, i&, j%, C%, N&, Brr
Range([Á`ªí!A1], Sheets("Á`ªí").UsedRange).Offset(2, 1).Clear
Brr = Range([¸ê®Æ!IV3].End(xlToLeft), [¸ê®Æ!A65536].End(xlUp)(1, 2))
K = [Á`ªí!A2]: N = 8: C = UBound(Brr, 2)
For j = 1 To C
   If K <> Brr(1, j) Then
      For i = 1 To N + 1
         Brr(i, j) = ""
      Next
   End If
Next
[Á`ªí!B3].Resize(N + 1, C) = Brr
End Sub

Andy2483

¤è®×2 ½Ð«e½ú°Ñ¦Ò:

Option Explicit
Sub TEST_2()
Dim K$, i&, j%, C%, N&, Brr, Crr
Range([Á`ªí!A1], Sheets("Á`ªí").UsedRange).Offset(2, 1).Clear
Brr = Range([¸ê®Æ!IV3].End(xlToLeft), [¸ê®Æ!A65536].End(xlUp)(1, 2))
K = [Á`ªí!A2]: N = 8: C = UBound(Brr, 2)
ReDim Crr(1 To UBound(Brr), 1 To C)
For j = 1 To C
   If K = Brr(1, j) Then
      For i = 1 To N + 1
         Crr(i, j) = Brr(i, j)
      Next
   End If
Next
[Á`ªí!B3].Resize(N + 1, C) = Crr
End Sub