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

[µo°Ý] ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk

[µo°Ý] ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk

¥¼©R¦W.png
2021-1-8 23:27

´ú¸ÕÀÉ¡J ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk.rar (179.22 KB)
·Q±NA¤u§@ªíªºB2:S51¡AV2:AM51¡AAP2:BG51¡ABJ2:CA51ªº¤½¦¡­È¡A
¥H¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº¤½¦¡­È¡A
¦U¶K¤WB105:AX122¡FB155:AX172¡FB205:AX222¡FB255:AX272(¥|­Ó°Ï¬q¦U18¦C)¡C
½Ð¸Ô¨£¡J(2021-01-05)_®ÄªGÀÉ

½Ð°Ý¡J
¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº»yªk¡AÀ³¸Ó¦p¦ó½s¼g¡H
ÁÂÁ¡I

PS¡J¦³¹w¯d1­ÓCSVÀÉ¥H§Q´ú¸Õ¥Î¡C

¦^´_ 17# ­ã´£³¡ªL
ª©¥D¤j¤j   : ±z¦n !
ÁÂÁ±zªº­@¤ß«ü¾É~·P®¦(Áù°`)

TOP

¦^´_ 16# ziv976688


Sub DATAÀÉ_AAAªí_¤½¦¡()
Dim AAA_Fx$(4), xR As Range, N%, xArea
AAA_Fx(1) = "=SMALL(IF(INDEX(A!$B$2:$S$51,,ROW($A1))="""",A!$A$2:$A$51),COLUMN(A$1))"
AAA_Fx(2) = "=SMALL(IF(INDEX(A!$V$2:$AM$51,,ROW($A1))="""",A!$A$2:$A$51),COLUMN(A$1))"
AAA_Fx(3) = "=SMALL(IF(INDEX(A!$AP$2:$BG$9,,ROW($A1))="""",A!$A$2:$A$9),COLUMN(A$1))"
AAA_Fx(4) = "=SMALL(IF(INDEX(A!$BJ$2:$CA$9,,ROW($A1))="""",A!$A$2:$A$9),COLUMN(A$1))"
For Each xR In Sheets("AAA").Range("B2,B52, B102, B152")
    N = N + 1
    xR.FormulaArray = AAA_Fx(N)
    xR.Copy xR(1, 2).Resize(1, 48)
    xR.Resize(1, 49).Copy xR(2, 1).Resize(17, 49)
    With xR.Resize(18, 49)
        .Value = .Value
        .Replace "#*", "", lookat:=xlWhole
    End With
Next
End Sub

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-1-16 08:23 ½s¿è

¦^´_ 9# ­ã´£³¡ªL
´ú¸ÕÀÉ : ·s¼W¸ê®Æ§¨.rar (152.36 KB)
ª©¥D¤j¤j : ±z¦n!
¤£¦n·N«ä¡A¦pªG±N
¤½¦¡A_D¼Ò²Õ
Sub DATAÀÉ_AAAªí_¤½¦¡()
Dim AAA_Fx$, xR As Range, N%, xArea
AAA_Fx = "=IF(COLUMN(A$1)>SUM(N(INDEX(A!°Ï°ì,,ROW($A1))="""")),"""",SMALL(IF(INDEX(A!°Ï°ì,,ROW($A1))="""",A!$A$2:$A$51),COLUMN(A$1)))"
xArea = Array("", "$B$2:$S$51", "$V$2:$AM$51", "$AP$2:$BG$51", "$BJ$2:$CA$51")   '¦C4
For Each xR In Sheets("AAA").Range("B2,B52, B102, B152")
    N = N + 1
    xR.FormulaArray = Replace(AAA_Fx, "°Ï°ì", xArea(N))
    xR.Copy xR(1, 2).Resize(1, 48)
    xR.Resize(1, 49).Copy xR(2, 1).Resize(17, 49)
    xR.Resize(18, 49).Value = xR.Resize(18, 49).Value
Next
End Sub
§ï¬°
~~~
~~~
xArea = Array("", "$B$2:$S$51", "$V$2:$AM$51", "$AP$2:$BG$9", "$BJ$2:$CA$9")   '¦C5
(¦]¬°¤F·j´MÀx¦s®æ=""®É¡A¨S¦³¼vÅT¡A¦ý¦pªG¬O­n·j´MÀx¦s®æ<>""©Î¨ä¥¦­È®É¡A·|¼vÅT¨ì³Ì²×ªºµª®×¡A©Ò¥H³o2­Ó½d³ò¥²¶·­n½Õ¾ã¬°¹ê»Úªº­pºâ¦C(8¦C))
~~~
~~~

½Ð°Ý :
¨ä¥¦¬ÛÃöªºµ{¦¡½X­n¦p¦ó¦A­×¥¿?
·q½Ð±z½ç¥¿¡A
ÁÂÁ±z^^

TOP

¦^´_ 14# jackyq
¨£¯º¤F!¥u¬O¹ï²Î­p¾Ç¦³¿³½ì¡A©Ò¥H§Q¥Î"·§²v"¨Ó¬ã¨s¼Ö³z½}¤F!
³o­Óª©¸ô¬O¤£¥XµP¥Îªº~¥Ø«eªº¬ö¿ý¬O³sÄò36´Á¨S¦³¯}ª©¡C
¥È¾Ç§¹¥þ¤£À´~«¢~«¢~

TOP

¦^´_ 13# ziv976688


³oµ{¦¡§A¦Û¤v¦b¥Îªº¼Ú

lotoµL¸Ñ  ³Ì²×´N¬O¨«¦V°Ñ¼Æ©t®q

¥Î¥È¾Ç·|¤ñ¸û¦³·Ç? §A¦³¤ñ¸û¹L¶Ü

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-1-10 15:06 ½s¿è

¦^´_ 11# ziv976688
Sorry~¦³µ§»~~13¬í§ï¬°33¬í
®Ä²v´£°ª37%

TOP

¦^´_ 10# n7822123
n¤j : ±z¦n!
¹ï¤p§Ì¦Ó¨¥¡A±zÄ@·NÀ°¦£©M«ü¾É~§Ú¤w¸g¬O·P¿E¤£ºÉ¤F
±zªº¦Ò¶q¬O¥¿½Tªº~±zªºµ{¦¡½X¹ï¤p§Ì¤]¬O¤Ó°ª²`~¤p§Ì¤@¯ë¬O¦³¬Ý¨S¦³À´¡AÁÙ¦n±z±`¦³¥[µù¸Ñ¡A¹ï¤p§ÌÀ°§U«Ü¤j(¨Ò¦p:§ï¬°539ªº®æ¦¡¡A¨ì¥Ø«e¬°¤î¡A³£¨S¦³¹J¨ì§xÃø)

¦A¦¸·PÁ±zªø´Á¥H¨Óªº¼ö¤ßÀ°¦£©M­@¤ß«ü¾É~´f§Ú¨}¦h~·P®¦¦A·P®¦(Áù°`)~~~ ~~~~~

TOP

¦^´_ 9# ­ã´£³¡ªL
ª©¥D¤j¤j   : ±z¦n !
®Ä²v´£°ª«Ü¦h~¦P¼ËªºÀɮשM¦P¼ËªºÀô¹Ò(ÃäÅ¥youtubeªº­µ¼Ö©MÃä¦b®à­±°õ¦æ¾Þ§@)¡A¥u¯Ó®É13¬í
·PÁ±z¤@ª½¥H¨Óªº¼ö¤ßÀ°¦£©M­@¤ß«ü¾É~¨ü´f¨}¦h~·P®¦¦A·P®¦(Áù°`)~~~ ~~~~

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-1-10 13:09 ½s¿è

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

ÁÙ¬O·Ç¤j¼F®`~~¤S§âµ{¦¡Â²¤Æ¤F~ ¡A µ{¦¡®Ä²v·|¦bUP

¦pªG§å¦¸°õ¦æ49­ÓÀɮסAAªí¤º®e³£¤£·|ÅÜ¡A¤½¦¡¤]¬O©T©wªº

¨ººâ¥X¨Óªº­È¤]¤£·|ÅÜ¡A½T¹ê¤£¥Îºâ¨º»ò¦h¦¸

¦b°j°é¥~ºâ¥X¨Ó¤@¦¸§Y¥i¡A¤§«á¨C­ÓÀɮ׳£¥u­n½Æ»s¸Ó­È~

¨º4­Ó¤½¦¡A~D¡A§Ú­ì¥»¤]·Q­n¹³·Ç¤j¨º¼Ë¦X¨Ö¼g¡A¥u§ï°Ï°ì½d³ò

¦ý¬O¦Ò¶q¨ì»Ý¨DªÌ¤£¾ÕªøVBA¡A©Ò¥H§Ú´NºÉ¶q¤£¥h°Ê¤F

µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD