- ©«¤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
|
¦^´_ 6# tonycho33 - Sub Ex()
- Dim Criterion As Range, Rng As Range, E As Range
- Set Criterion = Range([G5], [G5].End(xlDown)) 'G5¥H¤Uªº½d³ò
- Criterion.CurrentRegion.Offset(, 1) = "" 'G5ªº³sÄò½d³ò©¹¥k1Ä椧½d³ò
- For Each E In Criterion '¨Ì§Ç³B²z G5¥H¤Uªº½d³òªºCell
- Set Rng = [B:B].Find(E, lookat:=xlWhole) '§ä¨ìG5¦bBÄ檺¦ì¸m
- If Not Rng Is Nothing Then
- i = 0
- Do
- E.Offset(, i + 1) = Rng.Offset(i, 1)
- i = i + 1
- Loop Until Rng.Offset(i) <> "" Or Rng.Offset(i, 1) = ""
- End If
- Next
- End Sub
½Æ»s¥N½X |
|