ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸óÄæ¹ï¤ñ

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-3-5 13:35 ½s¿è

¦^´_ 20# 198188

§Ç¸¹Äæ­ì¥»¨S¦³¦X¨ÖÀx¦s®æ,°ò©ó¸ê®Æªº§¹¾ã©Ê,§Ç¸¹³£¤@©w·|¦³,©Ò¥H¥HAÄæ³Ì«á¦³¤º®eÀx¦s®æ¨Ó§PÂ_¨äÁa¦V½d³ò,
¦p¤µ¦pªG§ï¬°¦³¦X¨ÖÀx¦s®æ,¥i¥H¥H¼Ò¸¹ÄæBÄæ§PÂ_Áa¦V½d³ò
­ì¥»  Set xA = Range(ActiveSheet.[G1], ActiveSheet.[A65536].End(3))
§ï¬°  Set xA = Range(ActiveSheet.[G1], ActiveSheet.[B65536].End(3)(1, 0))
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 20# 198188

¼Ò号..."©T©w"¥u¦bA¤ÎHÄæ?? ¨ä¥¦Äæ¦ì¨S¦³?
¤u§@¶µ¥Ø...¥u¦³"¼Qªo"???

TOP

¦^´_ 22# ­ã´£³¡ªL


    ©Ò¦³¦ì¸m©T©wÄæ¦ì¡A¥u¦³°õ¦æªº¤u§@ªí¦WºÙ·|¦³¤£¦P¡C

TOP

¦^´_ 21# Andy2483


    §ï¤F¡A¤£¹LÁÙ¬O¤@¼Ë¡C
´Nºâ¤£¬O¦X¦}ªºÀx¦s®æ¤]µo¥Í¤£¯àŪ¨úªº°ÝÃD¡C
§A¬Ý¬Ýªþ¥ó¡A§Ú§ï§¹¦Z¡A¹B¦æ¤F¡A¤]¬O¥X²{³o­Ó°ÝÃD¡C

¹ï¤ñ.rar (29.67 KB)

TOP

¦^´_ 22# ­ã´£³¡ªL


    ¥t¥~¦]爲VBAùØ­±¥Î¤¤¤å·|¦³¶Ã½X¡A©Ò¥H ¡¨¼Qªo¡§ ¨â¦r¤~¦w±ÆŪ¨ú KP & KH Àx¦s®æªº" ¼Qªo"

TOP

¦^´_ 24# 198188


    ­þ¤@µ§ µo¥Í¤£¯àŪ¨úªº°ÝÃD??
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 26# Andy2483


    ¹Ï¤ù¬O¥þ³¡µ²ªG¡A²Ä2-79¦æ¤w¸g¨S¦³¸ê®Æ¡A²Ä80¦æ¦³¡A²Ä81 -84¦æ¨S¦³¡A ²Ä85¦æ¦³¡C

TOP

¦^´_  Andy2483


    ¥i¥H¤F¡AÁÂÁ¡I

Set xA = Range([1!G1], [1!A65536].End(3))
Intersect([1!M ...
198188 µoªí©ó 2024-3-5 08:58


­×§ï¬°¥Îactivesheet´N­n¦bªí "1"¤U°õ¦æ,§_«h·|§ì¤£¨ì¸ê®Æ,
¦pªG¦b¤u§@ªí¤£§ó´«¶¶§Çªº«e´£¤U¥i¥H¥Î¤u§@ªí¯Á¤Þ¸¹

Option Explicit
Sub TEST()
Dim Arr, Brr, Crr, V$, Z, i&, T$, TT$, A, xA As Range, N%
Set Z = CreateObject("Scripting.Dictionary")
Set xA = Range(Sheets(1).[G1], Sheets(1).[B65536].End(3)(1, 0))
xA.Offset(1, 12).Resize(, 3).ClearContents:  Brr = xA
For i = 2 To UBound(Brr)
   T = Format(Trim(Brr(i, 2)), "0000000"): V = Format(Val(Brr(i, 7)), "0000000"): TT = T & "/" & V
   Z(TT) = i
Next
Arr = Sheets(1).[M1].Resize(UBound(Brr), 3)
A = Array(Range([KH!C1], [KH!A65536].End(3)), Range([KH!J1], [KH!H65536].End(3)), Range([KP!C1], [KP!A65536].End(3)), Range([KP!J1], [KP!H65536].End(3)))
For Each Crr In A
   Crr = Crr: N = N + 1
   For i = 3 To UBound(Crr)
      T = Format(Trim(Crr(i, 1)), "0000000"): V = Format(Val(Crr(i, 2)), "0000000"): TT = T & "/" & V
      If Z.Exists(TT) Then
         If Arr(Z(TT), 1) = "" Then
            Arr(Z(TT), 1) = Crr(1, 1)
            ElseIf InStr("/" & Arr(Z(TT), 1) & "/", "/" & Crr(1, 1) & "/") = 0 Then
            Arr(Z(TT), 1) = Arr(Z(TT), 1) & "/" & Crr(1, 1)
         End If
         Arr(Z(TT), N \ 3 + 2) = Crr(1, 3)
      End If
   Next
Next
Sheets(1).[M1].Resize(UBound(Brr), 3) = Arr
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 28# Andy2483


    ¥Î¤F³o­Óµ{¦¡¡A¹B¦æ¦Z¡Aµ²ªG¤]¸ò¤§«e¤@¼Ë¡C²Ä2-79¦æ¨S¦³¸ê®Æ¡A²Ä80¦æ¦³¡A²Ä81-84¦æ¨S¦³¸ê®Æ

TOP

¦^´_ 29# 198188


    ¸ê®Æ¸Ì¥i¯à¦³¬Ý¤£¨£ªº¯S®í²Å¸¹
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD