- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# chyong911
¸Õ¸Õ¬Ý- Private Sub ¬d¸ß_Click()
- Dim Sh(1 To 2) As Worksheet, Rng(1 To 2) As Range, P As Integer, i As Integer
- Dim Ar()
-
- Application.ScreenUpdating = False ''Ãö³¬¿Ã¹õ¸õÅD
- Set Sh(1) = Sheets("²¼¾Úñ¦¬³æ")
- Set Sh(2) = Sheets("À³¥I²¼¾Údata")
-
- Set Rng(1) = Sh(1).Range("W6") '¨ì´Á¤é
- Set Rng(2) = Sh(2).Range("C3") '®w¶Ç²¼³æ¸¹
-
- If Rng(2) = "" And Rng(2).End(xlDown).Row = Rows.Count Then
- MsgBox "À³¥I¸ê®Æ ¤¤ ¨S¦³ ®w¶Ç²¼³æ¸¹"
- Exit Sub
- End If
- ClearFunction ''²MªÅ¬d¸ßµ²ªG
-
- '°õ¦æ¬d¸ß
- P = 1
- Ar = Array("C", "V", "Y", "D") 'À³¥I²¼¾Údata n¾É¤JªºÄæ¦ì
- Do While Rng(2) <> "" '®w¶Ç²¼³æ¸¹¤£¬°ªÅÈ
- If InStr(Rng(2), Rng(1)) Then '§ä¨ì¿é¤J¨ì´Á¤é
- For i = 1 To 4 'X,Y,Z,AA Äæ¦ì
- Rng(1).Cells(P, i + 1) = Sh(2).Cells(Rng(2).Row, Ar(i - 1))
- Next
- P = P + 1 '¬d¸ß¨ì +1 ¦C¦ì
- End If
- Set Rng(2) = Rng(2).Offset(1) '¤U¤@Ó®w¶Ç²¼³æ¸¹
- Loop
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X |
|