- ©«¤l
- 405
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 489
- ÂI¦W
- 22
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-10-30
- ³Ì«áµn¿ý
- 2024-5-4
|
Sub Worksheet()
Dim LastRec As Integer
Dim i As Integer
Worksheets("Oracle").Range("G1").Select
ActiveCell.End(xlDown).Select
LastRec = ActiveCell.Row
For i = 2 To LastRec
Worksheets("Oracle").Range("A" & i).Value = Worksheets("Oracle").Range("G" & i).Value '±NGÄ檺ÈCOPY¨ìAÄæ
If IsError(Application.VLookup(Worksheets("Oracle").Range("C" & i).Value, Sheets("Follower").Range("A:E"), 5, False)) Then
Worksheets("Oracle").Range("B" & i).Value = "" °²¦pSHEET ORACLE CÄ檺ȦbSHEET FOLOWER A¡GEÄæ§ä¤£¨ì¡A´N±NBÄæ³]©wªÅ®æ
Else
Worksheets("Oracle").Range("B" & i).Value = Application.VLookup(Worksheets("Oracle").Range("c" & i).Value, Sheets("Follower").Range("A:E"), 5, False) §_«h±NSHEET ORACLE CÄæ¦bSHEET FOLLOWER´M§ä¬Û¦P¡A¨Ã±N¬Û¦PªºEÄæÈ©ñ¦bSHEET ORACLE BÄæ
End If
Next i
i = i + 1
End Sub
¹B¦æ¤j¬ù7000ROW,¦ý¹B¦æ±o«ÜºC¡A½Ð°Ý¦U¦ì¤j¤j¡A¦³¨S¦³¥i¥H¥[§Ö¹B¦æªº¤èªk¡H |
|