- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-4-20
|
ÁקK¿ù»~, ¼g±oÅo¶Û¨Ç, ¦h¤@¨Ç°»¿ù:
Sub ½Æ»s¤½¦¡()
Dim R&, T$, xA As Range, xB As Range, xE As Range
With Sheets("¥i¥X¦Ü¤¤¤È")
R = .[A65536].End(xlUp).Row - 2 'n½Æ»sªºµ§¼Æ
If R <= 0 Then MsgBox "µL®Æ¸¹! ": Exit Sub
If .[B2] = "¤w½Æ»s" Then MsgBox "¤w½Æ»s¹L, ½Ð½T»{! ": Exit Sub
T = .[C2] '¤½¦¡¨Ó·½
If T = "" Then MsgBox "½Ð¿é¤J¤½¦¡¨Ó·½! ": Exit Sub
Set xA = .[A3].Resize(R) '®Æ¸¹½d³ò
End With
'------------------------------------
Set xB = [ÀH¤â¶K!B:B].Find(T, Lookat:=xlWhole)
If xB Is Nothing Then MsgBox "¤½¦¡¨Ó·½¿ù»~! ": Exit Sub
Set xB = [ÀH¤â¶K!A1:O1].Offset(xB.Row - 1, 0) '¤½¦¡¨Ó·½¦æ
'-----------------------------------
Set xE = [¤é»x!B65536].End(xlUp)(2) 'BÄæ§ä³Ì«á¤@µ§,¨Ã©w¦ì¤U¤@ªÅ¥Õ¦æ(2)
xB.Copy xE(1, 0).Resize(R) '½Æ»s¤½¦¡-->AÄæ(BÄ檺¥ª1®æ)
xE(1, 5).Resize(R) = xA.Value '¶ñ¤J®Æ¸¹-->FÄæ(BÄ檺¥k5Äæ)
[¥i¥X¦Ü¤¤¤È!B2] = "¤w½Æ»s" '¼Ð¥Ü[¤w½Æ»s]ÁקK«ÂЧ@·~, n½Æ»s·sªº®Æ¸¹, ¥ý²M°£B2
End Sub
Xl0000106.rar (16.83 KB)
======================================= |
|